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: 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

retrieving BLOB column..

2001-07-24 Thread Saurabh Sharma 



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..

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 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