有个问题一直想不通,请问有人知道ASP能否调用oracle大型字段BLOB,CLOB............
set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.ActiveConnection = MM_conn_STRING
rs1.Source = "SELECT IDNO, NTNAME, CONTENT, STATSNO, CREATDATE, CONTENT1 FROM ZDWY.NEWSINDEX ORDER BY CREATDATE DESC"
rs1.CursorType = 0
rs1.CursorLocation = 3
rs1.LockType = 3
rs1.Open()
因为上传文章有时太大了,用VARCHAR2(4000)不够用
所以想到了大型对象BLOB,CLOB.........等等
就在数据表里增加一个CONTENT1属于BLOB,但在ASP就报错了
-------------错误原因:不支持此接口
如果把CONTENT1不选,那程序正常