I have an image that is in a table and I'm trying to get it to display in a report. The upload takes place on 1 page and the report is on another page. The source for the report page is as follows:
select firstname,
lastname,
decode(nvl(dbms_lob.getlength(IMAGE),0),0,null,
'<img '||
'src="'||
apex_util.get_blob_file_src('P1_PHOTO',username)||
'" height="75" width="75" alt="Product Image" title="Product Image" />')
detail_img
from user_image
P1_PHOTO is the upload item on page 1. My report is on another page. The image is not displayed in the report. Any ideas would be appreciated.