I want to do it in PL/SQL, not in Java, Thanks.
"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message
news:92eeeff0.0301270727.7d771a77_at_posting.google.com...
> "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
>
>
> 1) 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.
>
> 2) 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 - 10:21:50 CST
