还是不行,访问方法: oConnstr="provider=oraoledb.oracle;data source=dbsid;user id=a;password=a;" set conn=server.createobject("adodb.connection") conn.open oConnstr set rs=server.createobject("adodb.recordset") sql="select content from a where id=1" rs.open sql,conn
Cause: An attempt was made to execute a new operation before the active non-blocking operation completed or a new operation was attempted before all the pieces of a column were inserted or fetched.Action: Execute the new operation after the non-blocking operation completes. If piecewise binds/defines were done, execute the new operation after all the pieces have been inserted or fetched.I suspect the nonblocking operation in question is due to the way you're reading 1000 bytes at a time out of the LOB. If you do a lob.read() you should slurp the entire contents of the lob at once, which may make that problem go away.DCOracle2 does piecewise binds only for LONG colums, not LOBs, but I expect the problem has to do with some kind of lingering on the LOB.
http://www.fawcette.com/china/print.aspx?TotalPage=6&ID=76这两个内容对你相对重要
这样多半能解决!万一不行,你得告诉偶你访问数据库的方法。
oConnstr="provider=oraoledb.oracle;data source=dbsid;user id=a;password=a;"
set conn=server.createobject("adodb.connection")
conn.open oConnstr
set rs=server.createobject("adodb.recordset")
sql="select content from a where id=1"
rs.open sql,conn
就是因为这个原因,当初上项目的时候,偶才否定了这个方案。在前台,你是如何将类容插入的?是利用缓冲字节流还是?那只能查一下oracle公司的文档,最好编写后台存储过程,专门操作大对象!!
non-blocking operation completed or a new operation was attempted before
all the pieces of a column were inserted or fetched.Action: Execute the new operation after the non-blocking operation
completes. If piecewise binds/defines were done, execute the new
operation after all the pieces have been inserted or fetched.I suspect the nonblocking operation in question is due to the way you're
reading 1000 bytes at a time out of the LOB. If you do a lob.read() you
should slurp the entire contents of the lob at once, which may make that
problem go away.DCOracle2 does piecewise binds only for LONG colums, not LOBs, but I
expect the problem has to do with some kind of lingering on the LOB.
<%
const ORADB_DEFAULT = &H0
const ORASQL_DEFAULT = &H0
const ORASQL_NO_AUTOBIND = &H1
const ORASQL_FAILEXEC = &H2const OK = 0
const ERROR = 32767const ORATYPE_VARCHAR2=1
const ORATYPE_NUMBER=2
const ORATYPE_SINT=3
const ORATYPE_FLOAT=4
const ORATYPE_STRING=5
const ORATYPE_VARCHAR=9
const ORATYPE_DATE=12
const ORATYPE_UINT=68
const ORATYPE_CHAR=96
const ORATYPE_CHARZ=97
const ORATYPE_CURSOR=102
const ORATYPE_CLOB = 112
const ORATYPE_BLOB = 113
const ORATYPE_BFILE = 114
const ORATYPE_VARRAY = 247const ORAPARM_INPUT=1
const ORAPARM_OUTPUT=2
const ORAPARM_BOTH=3 dim sqlstr
‘数据库连接语句略
clob_test1_rs.open sqlstr,conn
//以下两句重要 clob_test1_rs.MoveLast
set content1= clob_test1_rs.Fields("content").Value
AmountRead = content1.Read(buffer)buffer就是读出的内容
AmountRead = content1.Read(buffer)
clob_test1_rs.MoveLast
错误信息:行集不支持方向取。将该行去掉,此行又出现问题:
set content1= clob_test1_rs.Fields("content").Value
错误信息:缺少对象:'[string: "