Home -> Usenet -> comp.databases.oracle -> BLOB to File

BLOB to File

From: Upendra Mishra <upendram_at_teri.res.in>
Date: 19 Jun 2003 22:18:01 -0700
Message-ID: <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


Received on Fri Jun 20 2003 - 07:18:01 CEST












Original text of this message