用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