Hey there!
I have a problem with displaying an image on Oracle APEX as it shows "x" instead of the image itself.
The query that I have is pasted below where detail_image2 is set as "Plain Text (based on List of Values).
Thank you in advance!
select classification,
productType,
description,
irn,
dbms\_lob.getlength(sd\_blob) sd\_blobber,
comments,
to\_char(uploadDate, 'MM-DD-YYYY HH24:MI:SS') uploadDate,
to\_char(modifiedDate, 'MM-DD-YYYY HH24:MI:SS') modifiedDate,
username,
dbms\_lob.getlength(image\_blob) detail\_image,
decode(nvl(dbms\_lob.getLength(image\_blob), 0), 0, null,
'\<a href = "' || apex\_util.get\_blob\_file\_src('P201\_IMAGE', irn) || '">' || '\<img src="'
|| apex\_util.get\_blob\_file\_src('P201\_IMAGE', irn) || '" height="75" width="75" />' || '\</a>') detail\_image2
from pcu\_file\_upload
where to\_date(to\_char(decode(:P3\_UDFROM, '', to\_date('01-01-1990', 'MM-DD-YYYY'), uploadDate), 'MM-DD-YYYY'), 'MM-DD-YYYY') between to\_date(decode(:P3\_UDFROM, '', '01-01-1990', :P3\_UDFROM), 'MM-DD-YYYY') and to\_date(decode(:P3\_UDTO, '', '01-01-1990', :P3\_UDTO), 'MM-DD-YYYY')
and to_date(to_char(decode(:P3_MDFROM, '', to_date('01-01-1990', 'MM-DD-YYYY'), modifiedDate), 'MM-DD-YYYY'), 'MM-DD-YYYY') between to_date(decode(:P3_MDFROM, '', '01-01-1990', :P3_MDFROM), 'MM-DD-YYYY') and to_date(decode(:P3_MDTO, '', '01-01-1990', :P3_MDTO), 'MM-DD-YYYY')
and decode(:P3\_HCLASSIFICATION, '', '1', classification) = decode(:P3\_HCLASSIFICATION, '', '1', :P3\_HCLASSIFICATION)
and decode(:P3\_HPRODUCTTYPE, '', '1', productType) = decode(:P3\_HPRODUCTTYPE, '', '1', :P3\_HPRODUCTTYPE)
and decode(:P3\_IRN, '', '1', irn) = decode(:P3\_IRN, '', '1', :P3\_IRN)
and trim(lower(decode(:P3\_USERNAME, '', '1', username))) = trim(lower(decode(:P3\_USERNAME, '', '1', :P3\_USERNAME)))