I am trying to read a clob field from Oracle 9i using OraOLEDB.Oracle driver using ADO. The field contains HTML data.
set rs = server.CreateObject("adodb.recordset")
set rs = db.conn.execute("select contentbody from rbs_kz.tbl_content where c_id=2")
if not (rs.eof and rs.bof) then
iChunkSize = rs("contentbody").ActualSize
body = rs("contentbody").GetChunk(iChunkSize )
response.Write "body=" & body
The data comes back with the first character of the data only. Have tried so many things. Any help appreciated. Would also rather not use CLOB, is there an alternative? I need to be able to use it in the WHERE statement of a query so think that LONG is not possible.