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 [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
RE: retrieving BLOB column..
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 PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh SharmaSent: Tuesday, July 24, 2001 8:10 AMTo: 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 [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
RE: retrieving BLOB column..
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:[EMAIL PROTECTED]]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 [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html