APEX

Hi everyone,

I’m facing an issue with BLOB columns in an Interactive Report in Oracle APEX.

I have an Interactive Report built on a table that contains two BLOB columns:

• PHOTO_BLOB
• SIGN_BLOB

To display these images in the report on the frontend, I created Application Processes that stream the BLOB content using Application Processes and referenced them in the report query like this:

SELECT 
   ENTRY_ID,
   FULL_NAME,
   EMAIL,
   AGE,
   SCHOOL_ORGANIZATION,
   '<img src="f?p=&APP_ID.:0:&SESSION.:APPLICATION_PROCESS=display_img_blob&X01=' 
   || ENTRY_ID || 
   '" style="height:30px;" />' AS PHOTO,
   '<img src="f?p=&APP_ID.:0:&SESSION.:APPLICATION_PROCESS=display_sign_blob&X01=' 
   || ENTRY_ID || 
   '" style="height:30px;" />' AS SIGN,
   CREATED_AT
FROM PETITION_ENTRIES;

On the frontend, the images display perfectly in the Interactive Report. But when I download/export the report, the PHOTO and SIGN columns appear empty in the downloaded file.

There are no errors, no broken image icons, just blank columns.

How to fix it?