Re: help about BLOB

Thomas Kyte wrote:

> In article <3D0E0220.5F73C01B_at_exesolutions.com>, Daniel says...
> >
> >Drifter wrote:
> >
> >> hi NG
> >> is there a way to create a file with the content of a blob?
> >> for example: if i have a table with a BLOB data type (column) in which
> >> there are some binary things, can i create a file (in the File Sistem called
> >> "test.dat") with these binary things?
> >> best regards
> >> ~Carmine
> >
> >You can write the contents of a BLOB field out to a file on the hard disk using
> >the DBMS_LOB package.
> >
> >Daniel Morgan
> >
>
> you can READ the contents of a file into a blob using dbms_lob.
>
> You cannot WRITE
>
> see
> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4144686815509
>
> for an approach.
>
> --
> Thomas Kyte (tkyte_at_oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp

Correct. My fingers moved faster than my mind.

Daniel Morgan Received on Tue Jun 18 2002 - 22:39:10 CEST