Hello APEX people,
I'm working on Oracle Apex 24.1.0 and I used an apex temp collection to store the ID, Name and BLOB of every image that I've upoaded and when I want to display all this info in a classic report or any other type of report I can't find a solution to display the images ( DBMS_LOB.GETLENGTH(BLOB001) ) and the reason is because you don't have the option to select the blob column as you can do when you are retrieving the data from a permanent table in the database. Does anyone know how to figure this out ? And I prefer it to be a solution other than making the collection a view.
Thank you.