3 Replies Latest reply: Jul 31, 2013 2:30 PM by user8058501 RSS

    How to print a BLOB (image) on a PDF report using Oracle APEX Listener as Print Server

    user8058501

      Hi,

      I use APEX 4.2.

      I have the following query as SQL text for a Report Queries in Shared Components:

       

      select

          customer_id,

          cust_first_name,

          cust_last_name,

          cust_street_address1,

          cust_street_address2,

          cust_city,

          cust_state,

          cust_postal_code,

          phone_number1,

          phone_number2,

          credit_limit,

          cust_email,

          filename,

          company_profile,

          -- customer_image,

          decode(nvl(dbms_lob.getlength(customer_image),0),0,null,

          '<img style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '||

          'src="' ||

          apex_util.get_blob_file_src('P22_CUSTOMER_IMAGE', customer_id) ||

          '" height="75" width="75" alt="Photo Customer" title="Photo Customer" />') customer_image,

          mimetype,

          image_last_update

      from

          demo_customers;

       

      I am unable to have the image printed on the PDF report. Even when the P22_CUSTOMER_IMAGE is defined as session state item.

       

      Does someone knows how to print such image/BLOB in a PDF report?

       

      Thanks by advance.

      Kind Regards.