Re: BLOBs question

From: Andrey Bronfin <bronfin_at_VisualTop.com>
Date: Thu, 22 Jun 2000 17:28:14 +0200
Message-Id: <10536.110153@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0812_01BFDC6F.3EBB5C10
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks Walt !
I read this doc , but it says NOTHING about extracting BLOB into a file = !
It explains how to populate a BLOB from a file , but not vice versa ....

Didn't anyone on this list ever extract a BLOB into a file ?

TIA .

Original Message -----=20 From: Weaver, Walt=20 To: 'Andrey Bronfin' ; ORACLE-L_at_fatcity.com ; oracledba_at_quickdoc.co.uk =

Sent: Thursday, June 22, 2000 4:00 PM
Subject: RE: BLOBs question

  Check out Doc ID 61737.1 on MetaLink. I think it has the information = you're looking for.
  =20
  --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_000_0812_01BFDC6F.3EBB5C10
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =

http-equiv=3DContent-Type>

<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Thanks Walt !</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I read this doc , but it says =

NOTHING about=20
extracting BLOB into a file !</FONT></DIV> <DIV><FONT face=3DArial size=3D2>It explains how to populate a BLOB from = a file ,=20
but not vice versa ....</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Didn't anyone on this list ever extract = a BLOB into=20
a file ?</FONT></DIV>

<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>TIA .</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:wweaver_at_rightnowtech.com"=20   title=3Dwweaver_at_rightnowtech.com>Weaver, Walt</A> </DIV>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20   href=3D"mailto:bronfin_at_VisualTop.com" = title=3Dbronfin_at_VisualTop.com>'Andrey=20   Bronfin'</A> ; <A href=3D"mailto:ORACLE-L_at_fatcity.com"=20   title=3DORACLE-L_at_fatcity.com>ORACLE-L_at_fatcity.com</A> ; <A=20   href=3D"mailto:oracledba_at_quickdoc.co.uk"=20   title=3Doracledba_at_quickdoc.co.uk>oracledba_at_quickdoc.co.uk</A> </DIV>   <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, June 22, 2000 = 4:00=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: BLOBs = question</DIV>
  <DIV><BR></DIV>
  <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20   class=3D940230114-22062000>Check out Doc ID 61737.1 on MetaLink. I = think it has=20
  the information you're looking for.</SPAN></FONT></DIV>   <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20   class=3D940230114-22062000></SPAN></FONT> </DIV>   <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20   class=3D940230114-22062000>--Walt Weaver</SPAN></FONT></DIV>   <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20   class=3D940230114-22062000>  Bozeman, Montana, = USA</SPAN></FONT></DIV>
  <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">     <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20

size=3D2>-----Original Message-----<BR><B>From:</B> Andrey Bronfin = [<A=20

=
href=3D"mailto:bronfin_at_VisualTop.com">mailto:bronfin_at_VisualTop.com</A>]<B= R><B>Sent:</B>=20

Thursday, June 22, 2000 8:54 AM<BR><B>To:</B> <A=20 href=3D"mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_fatcity.com</A>; <A=20 =
href=3D"mailto:ORACLE-L_at_lists.sunysb.edu">ORACLE-L_at_lists.sunysb.edu</A>; = <A=20

=
href=3D"mailto:oracledba_at_quickdoc.co.uk">oracledba_at_quickdoc.co.uk</A><BR>= <B>Subject:</B>=20

BLOBs question<BR><BR></DIV></FONT>

    <DIV><FONT face=3DArial size=3D2>Hi !</FONT></DIV>
    <DIV>&nbsp;</DIV>
    <DIV><FONT face=3DArial size=3D2>Did anyone ever succeed to unload a =

contents of=20

    a BLOB to a file ?</FONT></DIV>
    <DIV> </DIV>
    <DIV><FONT face=3DArial size=3D2>I succeed to do it for CLOB or even = for BLOB=20

which contains text using DBMS_LOB and UTL_FILE .</FONT></DIV> <DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>But UTL_FILE may be used only for = TEXT data=20

    .</FONT></DIV>
    <DIV> </DIV>
    <DIV><FONT face=3DArial size=3D2>And what about pictures or other = raw data=20

    ?</FONT></DIV>
    <DIV> </DIV>
    <DIV><FONT face=3DArial size=3D2>I load the pictures into DB from a = file with=20

SQL*Loader or via BFILE - no problems .</FONT></DIV> <DIV><FONT face=3DArial size=3D2>But i did not find a way to write = into a BFILE=20

from BLOB and i can't use UTL_FILE for binary data .</FONT></DIV>

    <DIV><FONT face=3DArial size=3D2>Any ideas ?</FONT></DIV>
    <DIV>&nbsp;</DIV>
    <DIV><FONT face=3DArial size=3D2>Thanks a lot in advance =

.</FONT></DIV>

<DIV> </DIV>
<DIV> </DIV> Received on Thu Jun 22 2000 - 10:28:14 CDT