Re: help about BLOB

[Quoted] 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