Skip to Main Content

Application Development Software

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!

How to access IFS document contents in PL/SQL procedure ?

176632Mar 13 2002
I am interested in using IFS as a way to load documents
(PDF, HTML, RFT, text...) in an Oracle database table, and
then access the table via a regular application Server.

I understand that the right way to do this is via a Java API
mapped on top of IFS.

But we already have a fairly sophisticated web application using
Java and PL/SQL procedures so that I would ideally need
to write a PL/SQL procedure such as :
function get_document (ifs_file_name in varchar, ifs_file_path in varchar) return clob

For this I need to outline how to query the IFS schema using SQL.

Any idea which table to query ?

Have a nice day
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 22 2002
Added on Mar 13 2002
5 comments
773 views