Quick Upgrade Guide

When you already have an older version of AOP installed, follow this guide.

This guide will update the PL/SQL packages and the Oracle APEX plug-ins for AOP

  1. Unzip the file you downloaded from https://www.apexofficeprint.com

  2. Update the PL/SQL API.

  3. Go in APEX to SQL Workshop > SQL Scripts > Upload

  4. Select file /apex_version_\<version>/db directory/aop_db_pkg.sql

  5. Give it a name and click the Upload button.

  6. Click the run icon for the script you just uploaded, confirm that the schema in the upper right-hand corner of the screen is correct and click Run Now.

  7. All statements should be successful.

Repeat the above for /apex_version_\<version>/db directory/aop_modal_pkg.sql

The aop_db_pkg.sql file will update the AOP tables, PL/SQL API for the new version, and synonyms needed to use AOP. The synonyms will be set to point to the new version of AOP, but you can easily switch back to the previous version by changing the synonyms.
The aop_modal_pkg.sql file will update the required components for the AOP Modal APEX plug-in.

  1. Import new versions of the plug-ins.

  2. Go in APEX to App Builder > Your application > Shared Components > Plug-ins > Import

  3. Be sure to select the directory that corresponds to the version of Oracle APEX you are using - NOT the version of AOP.

  4. Select file apex_version_\<version>/plugin/process_type_plugin_be_apexrnd_aop.sql (for the AOP Process type plug-in)

  5. Select file apex_version_\<version>/plugin/dynamic_action_plugin_be_apexrnd_aop_da.sql (for the AOP Dynamic Action type plug-in)

  6. Select file apex_version_\<version>/plugin/dynamic_action_plugin_be_apexrnd_aop_convert_da.sql (for the Convert Dynamic Action type plug-in)

  7. Select file apex_version_\<version>/plugin/dynamic_action_plugin_be_apexrnd_aop_modal.sql (for the Modal Dynamic Action type plug-in)

  8. Enter the details of the AOP Server or in case the AOP Cloud is used the API key. If using the cloud version of AOP, make sure the API Key is set for each plug-in. An API Key is not necessary for on-premises installations.

That is it!

Optional you can also update the sample code

  1. Update the Sample PL/SQL Scripts.

  2. Go in APEX to SQL Workshop > SQL Scripts > Upload

  3. Select file /apex_version_\<version>/db/aop_db_sample_pkg.sql

  4. Give it a name and click the Upload button.

  5. Click the run icon for the script you just uploaded, confirm that the schema in the upper right-hand corner of the screen is correct and click Run Now.

  6. All statements should be successful.

  7. Update the AOP Sample Applications.

  8. If you already installed an older version of the AOP Sample App, we recommend to remove it first.

  9. Import the AOP Sample Apps you find in /apex_version_\<version>/app

For on-premises versions of AOP: Update the AOP Server

  1. Stop the AOP executable.

  2. Copy the server folder from the install package to your AOP Server

  3. Restart AOP with the new executable