日期:2014-05-17  浏览次数:20817 次

用asp向oracle数据库中插入long类型的纪录
我用asp向oracle数据库中插入long类型的纪录,当long型的纪录超过一定长度的时候就插不进去了,为什么,
我用的连接数据方法如下:
Set   rsSession   =   CreateObject( "OracleInProcServer.XOraSession ")
Set   rsDatabase   =   rsSession.DbOpenDatabase( "ora ", "jxsgl/jxsgl ", "0 ")
rsDatabase.DbExecuteSQL( "insert   into   tablename   (longitem)   values   ())
请问各位高手,我应该如何操作,谢谢

------解决方案--------------------
Set rsSession = CreateObject( "OracleInProcServer.XOraSession ")
Set rsDatabase = rsSession.DbOpenDatabase( "ora ", "jxsgl/jxsgl ", "0 ")
set rs=executeQuery( "select * from news_arch where archid= "&actionID)
rs.edit
rs.Fields( "nei ").DbAppendChunk(nei)
rs.DbUpdate
'executeUpdate(sql)
rs.close
set rs=Nothing