Skip to main content

Introduction

Overview​

The plug-in can be installed using

  • the sample application installation file exported from Oracle APEX application or
  • the manual installation using DDL scripting and plug-in installations files exported from Oracle APEX

The difference is that the manual installation installs only database objects required by the plug-in. In contrast, the sample application installation creates datanase objects needed to showcase examples presented in live demo application.

Depending on your Oracle APEX version, different files should be imported to your Oracle APEX scheme. The installation must be finished with the plug-in license activation. The plug-in documentation covers installation process for Oracle APEX before 22.2 and onwards.

learn more
  • database objects created after installation
  • the plug-in download bundle

Installation pre-requisites​

  • Oracle Database 12c or above
  • Oracle Application Express (APEX) 19.2 or above installed
  • the schema implementing an application where the plug-in will be installed must be REST enabled.

Sample application installation​

This method is the easiest and fastest because it comes down to importing and installing the sample application through Oracle APEX importing wizard. This method is the best in order to test the plug-in in your Oracle APEX enviroment immiedietly without any extra steps.

The sample application installation includes the following steps:

  1. Import sample application
  2. Install sample application with supporting objects
  3. Activate the plug-in license

The installation insctructions differs depending on Oracle APEX version, and you can read the instructions in the following documents:

The difference between sample application exported from Oracle APEX 19.2 and 22.2

The Oracle APEX session state supports page items values exceeding 32,768 characters since Oracle APEX 22.2. The plug-in bundle downloaded from our portal includes multiple files including sample application exported from Oracle APEX 19.2 and 22.2. These installation files allows you to install the plug-in in Oracle APEX before and after version 22.2.

The key difference is that the sample application exported from Oracle APEX 22.2 is already CLOB-enabled which means:

  • the plug-in instance in shared components plug-ins has standard attribute Session State Supports CLOB enabled
  • the plug-in page item implemented in home page and CLOB handling using the native Form component only example uses Session State \ Data Type set to CLOB
  • the sample application uses friendly URL syntax

The sample application exported from Oracle APEX 19.2 can be installed in Oracle APEX 22.2 onwards, but the sample application examples and plug-in instances must be CLOB enabled manually by a developer.

Manual installation​

This method requires manuall plug-ins installation followed by running DDL script creating the plug-in database objects (using Oracle APEX SQL Workshop).

The manual installation includes the following steps:

  1. Import & run the DDL script creating database objects
  2. Import & install the plug-ins
  3. Activate the plug-in license

Updating the plug-in​

When the plug-in is already used in Oracle APEX application and you want to upgrade the plug-in to the most recent version, just follow these steps:

  1. Import & run the DDL script ddl_uc_rte_update_plugin_pkgs.sql
  2. Import & install the plug-in and supporting plug-ins