Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 long text fields in Oracle database using ADO

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-11-06 : 16:16:26
Mel writes "I have a long text field (> 20K) stored as a CLOB datatype in an Oracle 8i database. I am using ADO in an .asp page to access the database, but there is no adCLOB enumerated datatype. I have tried adVariant and adLongVarChar, but I get a datatype mismatch error. How would you suggest I retrieve this field? Can you point me at an example? (I have seen code for BLOB fields, but not CLOB fields.)

Thanks,
--mel"
   

- Advertisement -