Skip to Main Content
Forums

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

TexasApexDeveloper

I believe you will need to use a custom layout built using an XML stylesheet editor... : http://www.oracle.com/technetwork/developer-tools/apex/learnmore/custom-pdf-reports-1953918.pdf

Thank you,

Tony Miller

SmartDog Services

Austin, TX

1 person found this helpful
Laury

Hi,

Thanks for the answer and my apologies for the delay.

Yes, this is probably the document I need.

I will read it first.

Kind Regards.

Laury

Hi,

Indeed, I would need a custom layout.

Unfortunately, it seems (according to this white paper) not possible with the APEX listener only. I would need a third pary tool. A pity...

For me strange, that I cannot generate such a report having images or pictures in a pre-definied report layout... Maybe a future enahancement for Oracle.

Kind Regards.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 28 2013
Added on Jun 28 2013
#pdf
3 comments
2,654 views