Message-Id: <10536.110141@fatcity.com> From: "Andrey Bronfin" Date: Thu, 22 Jun 2000 16:54:19 +0200 Subject: BLOBs question This is a multi-part message in MIME format. ------=_NextPart_000_0714_01BFDC6A.822944D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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_0714_01BFDC6A.822944D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi !

Did anyone ever succeed to unload a = contents of a=20 BLOB to a file ?

I succeed to do it for CLOB or even for = BLOB which=20 contains text using DBMS_LOB and UTL_FILE .

But UTL_FILE may be used only for TEXT = data=20 .

And what about pictures or other raw = data=20 ?

I load the pictures into DB from a file = with=20 SQL*Loader or via BFILE - no problems .

But i did not find a way to write into = a BFILE from=20 BLOB and i can't use UTL_FILE for binary data .

Any ideas ?

Thanks a lot in advance .