Displaying PDF from Oracle Application Server
I'm sorry if this topic ever discussed before. I need some clues how to display pdf file (adobe acrobat) via Oracle Application Server. Should I upload it first onto table or Oracle can read it from my directory directly (maybe using web.show_document)?
All comments would be appreciated.
What is the lanugage you are using tow display the PDF document Java PHP ? oracle reports ?
If you are using mod_plsql, something as simple as imbedding the file name in an anchor tag will work. You'd need to have apache configured to allow access to the directory your PDF file is in.
pi_file in varchar2)
l_web_root varchar2(200) := 'http://localhost/myroot/pdfs/';
htp.p(' Click for file ');
I'm using oracle - developer 6i (form & report). Can application server load it from directory e.q : c:\test or should I upload it into BLOB data type? Would you show me the script how to display it?
Thanks for your assistant. Displaying report in PDF format is ok but not oracle report I'm talking about. I Just have trouble after trying to view PDF file via Oracle Application Server. Just a file, not report.
Click Here to Expand Forum to Full Width