I am using Oracle 9i and forms 6i. I am trying to display a bfile within a form. I have read on blobs and it looks like I need to use dbms_lob.fileopen....but how? I tried to write the code in a trigger for a button to execute to display the file, but I'm not getting it right.
Table Lease_files
columns lessee_code number(4)
doc_date date
doc bfile
title varchar2(50)
I have created a directory for mydir showing the server path to the file. Now what?
Table Lease_files
columns lessee_code number(4)
doc_date date
doc bfile
title varchar2(50)
I have created a directory for mydir showing the server path to the file. Now what?