Re: BLOB to File

upendram_at_teri.res.in (Upendra Mishra) wrote in message news:<214aff7.0306192118.20a04f7e_at_posting.google.com>...
> Hi
> I am having some files stored in the database in table containg blob
> column.
> Say table is docs
> doc_id number /* id of document primary key*/
> doc_name varchar2 /* documnet name with extn say 'project.pdf'*/
> docs blob /* document contenet of 'project.pdf' */
> in which docs column contain the files.
> Now i want to put these files outside the operating system in a
> directory say
> 'c:\documents' . How shlud i be able to achieve this . I am using
> oracle 9i database.
>
> Thanx in advance
> 'Upendra

If you had googled on "write BLOB to file", you would have gotten plenty of hits. Download a free (I believe it's still free) tool called Utl_Binfile (Courtesy of Vladimir Zakharychev), that may do what you are looking for. Here is the URL,

http://www.dpsp-yes.com/dpsp/prod/!go?id_=ndownloads

Regards
/Rauf Sarwar Received on Fri Jun 20 2003 - 21:26:01 CEST