I
don't remember in ODBC/OLEDB, but in JDBC there's quite a nice streams interface
to CLOBs. You open the CLOB, then just read it as any other stream, for example
as if it were a disk file, using the CLOB as a handle rather than a file
descriptor.
g
-Original Message-From:
Saurabh,
Check out the DBMS_LOB package. There are lots of
procedures and functions for manipulating BLOBs and
CLOBs.
Jack
Jack C.
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit,
Inc.Austin,
Texaswww.iNetProfit.com[EMAIL