This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFDC52.38712492
Content-Type: text/plain;
charset="iso-8859-1"
Check out Doc ID 61737.1 on MetaLink. I think it has the information you're
looking for.
--Walt Weaver
Bozeman, Montana, USA
-----Original Message-----
From: Andrey Bronfin [mailto:bronfin_at_VisualTop.com]
Sent: Thursday, June 22, 2000 8:54 AM
To: ORACLE-L_at_fatcity.com; ORACLE-L_at_lists.sunysb.edu;
oracledba_at_quickdoc.co.uk
Subject: BLOBs question
Hi !
Did anyone ever succeed to unload a contents of a BLOB to a file ?
I succeed to do it for CLOB or even for BLOB which contains text using
DBMS_LOB and UTL_FILE .
But UTL_FILE may be used only for TEXT data .
And what about pictures or other raw data ?
I load the pictures into DB from a file with SQL*Loader or via BFILE - no
problems .
But i did not find a way to write into a BFILE from BLOB and i can't use
UTL_FILE for binary data .
Any ideas ?
Thanks a lot in advance .
------_=_NextPart_001_01BFDC52.38712492
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.2614.3500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=940230114-22062000>Check
out Doc ID 61737.1 on MetaLink. I think it has the information you're looking
for.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=940230114-22062000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=940230114-22062000>--Walt
Weaver</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=940230114-22062000>
Bozeman, Montana, USA</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Andrey Bronfin
[mailto:bronfin_at_VisualTop.com]<BR><B>Sent:</B> Thursday, June 22, 2000 8:54
AM<BR><B>To:</B> ORACLE-L_at_fatcity.com; ORACLE-L_at_lists.sunysb.edu;
oracledba_at_quickdoc.co.uk<BR><B>Subject:</B> BLOBs
question<BR><BR></DIV></FONT>
<DIV><FONT face=Arial size=2>Hi !</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Did anyone ever succeed to unload a contents of a
BLOB to a file ?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I succeed to do it for CLOB or even for BLOB
which contains text using DBMS_LOB and UTL_FILE .</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>But UTL_FILE may be used only for TEXT data
.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>And what about pictures or other raw data
?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I load the pictures into DB from a file with
SQL*Loader or via BFILE - no problems .</FONT></DIV>
<DIV><FONT face=Arial size=2>But i did not find a way to write into a BFILE
from BLOB and i can't use UTL_FILE for binary data .</FONT></DIV>
<DIV><FONT face=Arial size=2>Any ideas ?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Thanks a lot in advance .</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
Received on Thu Jun 22 2000 - 09:00:21 CDT
