Skip to main content

AOP Sample Applications


In order to use the latest version of APEX Office Print (AOP) you need Oracle APEX 19.2 or higher. For APEX 5.0.4 till 19.1 we ship an older version of AOP.


There are two versions of the APEX Integration AOP Sample App; one for Oracle APEX 19.2 till 23.1 and one for Oracle APEX 23.2. The APEX 23.2 sample application contains some features that are only available in new versions of APEX.

Import via the Import Wizard in Oracle APEX App Builder

There are 5 AOP Sample Applications in the /app directory. You can import the ones you like and import them in any order.

  • Getting started (aop_app_getting_started.sql): Connecting to the AOP Server, using the APEX Plug-ins and PL/SQL API.
  • Integration with APEX Components (aop_app_apex_features_192.sql/aop_app_apex_features_232.sql): Showcasing AOP with native APEX Components, such as Classic Reports, Interactive Reports, Interactive Grids, and more (use the 232 version for the latest version of APEX, or 192 for any previous version of APEX).
  • AOP Modal Plug-in (aop_app_modal_down_subscr.sql): Download & Subscription Manager application showing how to use the AOP Modal plug-in, the management of custom templates, and report scheduling.
  • AOP Features (aop_app_aop_features.sql): Take a look at all the amazing things AOP can do. Various Word, Excel, PowerPoint, HTML, and Text examples along with batch printing, PL/SQL API samples, and interfacing with external data sources.
  • PDF Features (aop_app_pdf_examples.sql): Examples of creating, editing, annotating, splitting, and merging PDFs. Plus filling and reading forms, security, signature capability, and more!

Make sure you run the supporting objects, and all back-end database objects will be created for you.

Import via Command Line

To import the AOP Sample Applications via command line, connect to the schema in which you would like to install the application and run the following:

apex_application_install.set_workspace('AOPDEMO'); -- replace AOPDEMO with your workspace
apex_application_install.set_schema('AOPDEMO'); -- replace AOPDEMO with your schema
apex_application_install.set_application_alias('AOP_' || apex_application_install.get_application_id);
apex_application_install.set_auto_install_sup_obj(p_auto_install_sup_obj => true );

@aop_app_apex_features_192.sql or aop_app_apex_features_232.sql (depending your Oracle APEX version)

The AOP Sample Application will also install all supporting objects, so after the import you can simply start using the application.

Trying the AOP Sample Application

The APEX application that comes with AOP shows different examples of how APEX Office Print can be used inside an application.
We really recommend going through our sample application and inspecting elements of the pages to quickly learn how to use AOP.