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.