Using Oracle APEX 19.2. I know how to upload an image or document (of any MIME type) into a table - what is uploaded is stored in a BLOB column. Also know how to give a thumbnail view of an uploaded image in an Interactive Report (currently at 100 x 100, can make it larger if needed - see script below).
There are two problems I am experiencing:
- showing a thumbnail view of the document (currently is only a blank box), and
- being able to click on either an uploaded document or image to view it - without needing to first download and save to a HD (especially for a document)
Have searched this APEX Forum and the internet for help - have not found anything. Was hoping someone here knows how to do this please.
The source I have for the Interactive Report is this SQL query:
select up.UPLOAD_ID,
_decode(nvl(dbms\_lob.getlength(up.UPLOAD), 0),_
_0,_
_NULL,_
_'\<img src="' ||_
_apex\_util.get\_blob\_file\_src('P31\_UPLOAD', up.UPLOAD\_ID) ||_
_'" height="100" width ="100" />') as PICTURE,_
_up.UPLOAD\_DESC as COMMENTS,_
_up.AIRCRAFT\_ID,_
_up.APPEAL\_ID,_
_up.TAIL\_NO,_
_up.MIME\_TYPE,_
_up.UPLOAD\_NM,_
_up.FILENAME,_
_up.START\_DT as DATE,_
_dbms\_lob.getlength(upload) DOWNLOAD_
from AC_UPLOAD up
where up.aircraft_id = :P33_AIRCRAFT_ID
_and up.appeal\_id = :P33\_APPEAL\_ID_
Here is an image of what the user sees on a model page, with the above Interactive Report source SQL code (edited the Tail # for privacy):
Thank you,
Rebecca