RE: retrieving BLOB column..

2001-07-25 Thread Guy Hammond
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:

RE: retrieving BLOB column..

2001-07-24 Thread Jack C. Applewhite
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