From guy.hammond@avt.co.uk Wed, 25 Jul 2001 06:00:19 -0700 From: "Guy Hammond" Date: Wed, 25 Jul 2001 06:00:19 -0700 Subject: RE: retrieving BLOB column.. Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 Sharma [mailto:ssharma1@fcsltd.com]Sent: Tuesday, July 24, 2001 2:10 PMTo: Multiple recipients of list ORACLE-LSubject: retrieving BLOB column.. hi all,   do any one tell me how can i retrieve from a blob column. these will be displayed in browser through asp page. r there any functions used to retrieved records(jpg files, gif) from a blob.   Saurabh Sharma   saurabh00pc@yahoo.comhttp://www.geocities.com/saurabh00pc/stride.html