Printable View
Dear All,
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.
Regards,
Zettira
Hi
What is the lanugage you are using tow display the PDF document Java PHP ? oracle reports ?
regards
Hrishy
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.
procedure show_pdf(
pi_file in varchar2)
is
l_web_root varchar2(200) := 'http://localhost/myroot/pdfs/';
begin
htp.p(' Click for file ');
end;
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?
Regard,
Zettira
Hi
http://www.oracle.com/technology/pro...nge/index.html
For displaying reports on the web read
http://www.oracle.com/technology/pro...m10gsrw10g.pdf
In that document read about web.show_document
regards
Hrishy
Hi,
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.
Regard,
zettira