selecting blobs using forms 6i to store on a local drive
373644Aug 18 2003 — edited Aug 22 2003Hi 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.