Oracle Application Express (MOSC)

MOSC Banner

Loading PDF Files into a refreshable static region using an Ajax Callback Process

I am running APEX 21.2 in Oracle 19c on an Oracle Database Appliance (x8 2s).

After researching possible methods for dynamically displaying PDF files in the browser's default PDF viewer (mine is Adobe Acrobat extension in the Edge browser), I thought I'd share what I think is a simple solution using minimal coding and configuration. This method assumes you have a table with at least two columns - a blob column for the PDF, and a varchar2 for storing the mimetype for the blob (for PDF use "application/pdf" for the mimetype). It uses a page item, button, application process, and a static content region to dynamically load pdf files from a database blob. Updating the

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center