Hi,
I am following the thread and it looks like it is for APEX 4.x (not 5.x)
Here is my use case:
We have a table consisting of candidate resumes. We need to view the resumes inline in Oracle APEX. The resumes are stored in PDF format in an oracle table in 12c.
I created a simple classic report and added the following SQL:
select id, blob_content from t1;
This does not display the blob content.
So I did setup the BLOB attribute settings.
When I run the report, we get an error ORA-06502: PL/SQL: numeric or value error:
To avoid that I changed the query to
select id, dbms_lob.getlength(blob_content) blob_content from t1;
I set this column as DISPLAY IMAGE and set the attributes for MIME_TYPE, FILENAME
Instead of displaying the PDF file, I am getting
How can I view the resumes and then go to the next record and view another resume? Currently, we can download the resumes and view it. I am more interested in viewing inline
Any feedback would be appreciated.
Thanks
Ajay
Message was edited by: Ajay Gandhi