Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

selecting blobs using forms 6i to store on a local drive

373644Aug 18 2003 — edited Aug 22 2003
Hi Oracle:
Here is my delemna. I have pdf's stored as blobs fields in the database. I want to retrieve these blob fields using forms 6i onto a clients machine, or if I can not put it on the clients machine then I would like to retrieve these blobs and store them to a directory on the database server. Currently I am using the DBMS_Lob package to take files stored on the database in a directory an upload them to a column in the database. This works great. Now I want to do the complete opposite. I want to select a blob column out of the database and store it to something like c:\blob.pdf either on the database but preferably on the client machine using forms 6i as he interface to do so. This is client server technology so I do not have to worry about web at all. Do you guys have any sample code on how to do this? Can dbms_lob accomplish this? Intermedia? UTL_File?
If you could provide sample code on how to select a blob from the database and save it to a local disk using forms 6i this would be much appreciated.

Regards,
Bob D.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2003
Added on Aug 18 2003
2 comments
348 views