Hi Everyone,
I’m working on an Oracle APEX 23.1 application with an Oracle Database 19c backend.
In my app, I store images (like PNG, JPEG, etc.) in a BLOB column.
I need to implement a feature where:
- Users can click an image (for example, from a form or an Interactive Report).
- On click, the image should open in a popup window or dialog for preview.
- Inside the same popup, users should have an option to download the image if they want.
I’m looking for a reusable solution that can work across the application — for example, from multiple pages or regions where images are displayed.
Could anyone please guide me on:
- How to design this popup or dialog for image preview?
- How to dynamically load the BLOB image into the popup when an image is clicked?
- How to include a “Download” button or link within the popup?
Any sample code, steps, or best practices would be greatly appreciated.
Thanks in advance!