Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

LauryJun 28 2013 — edited Jul 31 2013

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2013
Added on Jun 28 2013
3 comments
2,652 views