From japplewhite@inetprofit.com Tue, 24 Jul 2001 06:20:05 -0700
From: "Jack C. Applewhite" <japplewhite@inetprofit.com>
Date: Tue, 24 Jul 2001 06:20:05 -0700
Subject: RE: retrieving BLOB column..
Message-ID: <F001.003532A5.20010724063623@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



Saurabh<SPAN 
class=156393413-24072001>,
<SPAN 
class=156393413-24072001> 
<SPAN 
class=156393413-24072001>Check out the DBMS_LOB package.  There are lots of 
procedures and functions for manipulating BLOBs and 
CLOBs.
<SPAN 
class=156393413-24072001> 
<SPAN 
class=156393413-24072001>Jack
--------------------------------Jack C. 
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, 
Inc.Austin, 
Texaswww.iNetProfit.comjapplewhite@inetprofit.com(512)327-9068

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: root@fatcity.com 
  [mailto:root@fatcity.com]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
   
  <A 
  href="mailto:saurabh00pc@yahoo.com">saurabh00pc@yahoo.com<A 
  href="http://www.geocities.com/saurabh00pc/stride.html">http://www.geocities.com/saurabh00pc/stride.html