Displaying PDF from Oracle Application Server

[zettira]

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

[hrishy]

Hi

What is the lanugage you are using tow display the PDF document Java PHP ? oracle reports ?

regards
Hrishy

[rigatoni]

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;

[zettira]

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

[hrishy]

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

[zettira]

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