ADO and Oracle CLOBs
Posted on 2006-07-01
ok, I have a problem accessing an oracle CLOB from ADO / ASP.
Environment is Windows 2003 Server
I have setup a System DSN named dQA which uses the Microsoft ODBC for Oracle Driver
The connection and site has worked fine forever and a day. We have recently decided to convert a field in one of our tables from a LONG to a CLOB. I am now in the process of trying to debug / fix the ASP code to read the CLOB. I have seen too much information ... some saying that it can not be done or here is a solution ... and so I go down the path of it can be done.
Here is the SQL:
SELECT id AS msgID, Upper(to_text) AS msgToText, subj_text AS msgSubjText, status AS msgStatus, create_date AS create_date, modify_date AS modify_date, message_text AS msgMessageText, message_length AS msgMessageLen
WHERE message_type = 'XYZ'
AND id = 417955
AND to_date('04/21/2006','MM/DD/RRRR') < nvl(modify_date,create_date)
ORDER BY Create_date desc
** message_text AS msgMessageText is the CLOB field **
Getting an the following error:
Provider error '80004005'
GetMessageInfo.vbs, line 63 ... which is the open
I don't even get to the chance to getChunk to read the CLOB field ...
The rest of the site is fine ... all other pages not accessing this new CLOB field are fine.