0 Replies Latest reply: Jul 22, 2013 10:14 AM by 5c10d62f-35e4-4122-918e-409e66a7664f RSS

    PDF printing using APEX Listener 2.0.1 and with reverse proxy set up throws an error

    5c10d62f-35e4-4122-918e-409e66a7664f

      Hi,

       

      I have an APEX 4.2 application that has an email button, based on a pl sql process, which sends out an email with a pdf file created by APEX Listener.

       

      This worked well till reverse proxy was set up on the system. Once that happened, the url of the application was masked from http://foo.com/apex/app1 to https://bar.com/apex/app1. This has caused the email functionality to stop working. The button now throws an error:

       

      • ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.

       

      The email is a pl sql process that goes

       

      DECLARE

          l_id number;

          l_document BLOB;

          l_xml_data BLOB;

          l_mail_to varchar2(100);  

      BEGIN

       

       

      Select EMAIL_ID into l_mail_to from APPLICATION_USER WHERE lower(NED_ID) = lower(apex_authentication.get_login_username_cookie);

       

      l_document := APEX_UTIL.GET_PRINT_DOCUMENT

          (

          p_application_id=>'994',

          p_report_query_name=>'P43_AOA_Detail',

          p_report_layout_type=>'xsl-fo',

          p_document_format=>'pdf'

          );

       

      l_id := APEX_MAIL.SEND

            (

             p_to        => l_mail_to,       

             p_from      => 'test@test.com',

             p_subj      => 'DETAILS',

             p_body      => 'Please review the attachment.',

             p_body_html => 'Please review the attachment.'

             );

       

       

      APEX_MAIL.ADD_ATTACHMENT

             (

             p_mail_id    => l_id,

             p_attachment => l_document,

             p_filename   => 'DETAIL.pdf',

             p_mime_type  => 'application/pdf'

             );

       

       

      END;

       

      I'd appreciate any guidance with the same.

       

      Now, this is my first time posting a question on the forums. If I have missed out on any information that you'd like to see, let me know and I'll post it on here.

       

      Thanks.