Hi Everyone,
I’m working on an Oracle APEX 23.1 application with an Oracle Database 19c backend.
I have a table that stores files (documents and images) in a BLOB column.
Currently, users can download these files using a download link, but I want to show a preview (view) of the document or image before downloading it.
For example:
- Preview images directly in a region or modal dialog.
- Preview PDFs or other documents inside an inline viewer or popup before downloading.
Could anyone please suggest the best approach to implement this in APEX 23.1?
Are there any built-in components, dynamic actions, or PL/SQL techniques that can help display BLOB content for preview?
Any sample code or step-by-step guidance would be greatly appreciated.
Thanks in advance.