Displaying PDF from Oracle Application Server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Displaying PDF from Oracle Application Server

  1. #1
    Join Date
    Jan 2006
    Posts
    14

    Displaying PDF from Oracle Application Server

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

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

    regards
    Hrishy

  3. #3
    Join Date
    Nov 2003
    Location
    Ohio
    Posts
    51
    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;
    ____________________
    Pete

  4. #4
    Join Date
    Jan 2006
    Posts
    14

    Question

    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

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    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

  6. #6
    Join Date
    Jan 2006
    Posts
    14

    Question

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width