Re: writing blob to file on disk in pl/sql server

Using DBMS_LOB on its own will not do all you require, you can indeed read a line from a BLOB into a variable but you need to write it to the OS. If it was a CLOB you were dealing with you use UTL_FILE to write it to the OS. However, you cant use UTL_FILE for binary info so you will have to use an External Procedure.

This subject has been covered by myself and others in newsgroups, try doing a search via Google on the subject (saves me repeating myself!)

I know the following link works (cut and paste whole link into browser)

http://groups.google.com/groups?q=markg+blob&hl=en&selm=ab87195e.0201220107.6cdeeaeb%40posting.google.com&rnum=2

HTH, M

damorgan <damorgan_at_exesolutions.com> wrote in message news:<3CAB2AE9.6F415FEB_at_exesolutions.com>...
> Look at the DBMS_LOB package. Run the following:
>
> SELECT DISTINCT object_name
> FROM all_arguments
> WHERE package_name = 'DBMS_LOB';
>
> The answer will present itself.
>
> Daniel Morgan
>
>
>
> PS wrote:
>
> > i would like to write blob into file in pl/sql. I know how to get a
> > file from blob but i don't know how to write it as a file in PL/SQL.
> > Is it possible?
Received on Thu Apr 04 2002 - 11:14:29 CEST