"zorro" <z_at_z.com> wrote in message news:<BZ6Z9.129790$H7.5248099_at_news2.calgary.shaw.ca>...
> Hi,
>
> I know how to load a binary file into a BLOB column, but I'd like to do the
> opposite now and create a file on disk with the data from a BLOB column.
>
> Anybody can help ?
>
> Thank you,
> Denis
- Use dbms_lob and utl_file packages. You should be able to open an
io stream by getting RAW data from BLOB column by using dbms_lob.read
and output to a file using utl_file.Put_Raw, theorectically because I
have not tested it myself.
- Use java.sql and java.io api's and write a java stored procedure.
There are functions in java.sql to get to BLOB data. Look at
java.sql.Blob and java.sql.ResultSet.getBlob(). Once you get the
handle to InputStream from java.sql.Blob, you can use
java.io.FileOutputStream and write data to file.
Regards
/Rauf Sarwar
Received on Mon Jan 27 2003 - 09:27:26 CST
