Hello.
I'm using APEX 22.2 over a 21c DB. I have a table which is loaded with different types of files, stored in a BLOB field, some of them can be shown on the browser (mainly PDF, Bitmap graphic files, text files)
I want to allow the users to see those files on the browser in a pop up modal window. I'm already have the mime type of the each type of file stored on the table, and I'm able to show the content on the same page where are shown all the fields, but I want to show it on another window.
To get this done I defined two lines of work:
- Using Dynamic content show the BLOB field
- Create a modal page which have a link to the “Download Blob” field in a classic report, and programmatically click on the link.
For the first option, I've checked the post https://forums.oracle.com/ords/apexds/post/displaying-blobs-9087 with no result
For the second option, I've tested the suggestions on the post https://forums.oracle.com/ords/apexds/post/how-to-programatically-click-the-link-icon-in-first-row-of-9351 with no result either.
Please, can anyone share some ideas about how to get this done?
Regards.