Forum Stats

  • 3,827,807 Users
  • 2,260,823 Discussions
  • 7,897,380 Comments

Discussions

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

Laury
Laury Member Posts: 1,665 Silver Badge

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.

Laury

Answers

This discussion has been closed.