How do you use apex_util.get_blob_file_src in a report to show images
PaulPMay 20 2010 — edited May 21 2010I have a report and I want to display thumbnail images stored in a blob column in the report. In the advanced APEX course there is an example on P5-8 as follows:
select "EMPLOYEE_ID",
"FIRST_NAME",
"LAST_NAME",
"EMAIL",
case when dbms_lob.getlength(PHOTO) > 0
then '<img src= "'||apex_util.get_blob_file_src('P16_PHOTO',employee_id)||'" height="75" width="75" />'
end photo
from "#OWNER#"."OEHR_EMPLOYEES"
Please explain in detail the arguments to apex_util.get_blob_file_src().
Do I have to create a new item on the page called P16_PHOTO? If so what are the settings for the item's attributes? In a standard report one doesn't normally need items on the report page (except for parameters to the report).
I have had a look at Dimitri's blob at
http://dgielis.blogspot.com/2009/05/using-apexutilgetblobfilesrc-on-public.html
but can't get it to work for a report. I keep getting
report error:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
I assume that employee_id is read from OEHR_EMPLOYEES for each different row displayed.
regards
Paul P