how to retrieve data from CLOB datatype in Oracle being called from VB/ASP?

[chmc]

How can I retrieve data from a field of CLOB datatype in Oracle
8 being called from an ASP or VB application? The recordset
object in ASP or VB doesn't support the CLOB datatype.
Thank you in advance for your help.

[Grizzly]

Microsoft's OLE DB Provider for Oracle does not support that binary datatype. I've come to the understanding that you need to somehow get the Oracle OLE DB Provider in order to gain access to binary datatypes like BLOB's and CLOB's.

I found this article, which might be midly useful to you:
http://www.vbip.com/books/1861003927/chapter_3927_16.asp

[e_dawg]

Did you figure out how to do it?

Clob fields are a bit of a pain... We had so much trouble with them that we had to change our design to compensate for issues with using that data type in Java.

------------------
Founder of the Sharky (Ultra) High-Resolution Club[SHRC (http://www.sharkyforums.com/ubb/Forum17/HTML/005121.html)] [SHRC:ETCH (http://www.sharkyforums.com/ubb/Forum17/HTML/005121-5.html)]
[SGC Ultimate pass... Don't read anything I post unless you want a headache (http://www.sharkyforums.com/ubb/Forum17/HTML/005187.html)]
SF Linux Hippie Club Vice-Vice President (http://hippy.edawgcg.net/) [Card (http://hippy.edawgcg.net/e_dawg.html)]
America Online Doit Mourir
Everything you ever wanted to know and see about e-dawg... (http://edawg.edawgcg.net/)