Skip to main content

Prerequisites

Oracle APEX version​

These instructions are meant to be implemented in Oracle APEX 19.2 or above, where CLOB values in APEX session state are not natively supported.

Supported for all APEX versions

Page components implemented using these instructions will also work in Oracle APEX 22.2 onwards, but it's recommended to implement the plug-in relying on native APEX CLOB support. Learn more in the guidelines for Oracle APEX 22.2 onwards.

Oracle APEX page wizard​

To streamline the instruction, the guidelines utilize the APEX Page Wizard creating the native APEX form with the report. The Oracle APEX wizard automates the creation of all necessary pages and page components, simplifying the process into a few straightforward steps. While this initial setup may seem redundant, it serves as a foundation for subsequent customization.

Following the creation of all components by the wizard, the instruction focuses on modifying the form component using custom page PL/SQL processes implementing the plug-in PL/SQL API and the supporting process plug-in. The plug-in's PL/SQL API and supporting process plug-in enables CLOB support for APEX prior to 22.2.

Sample application installed​

The implementation guidelines for Oracle APEX 19.2 and above describe step-by-step instructions in assumptions that the plug-in sample application is installed in the same APEX scheme.

shortcuts

An application plug-ins subscriptions​

The guidelines are describing step-by-step instructions for a new application with defined plug-ins subscriptions from the sample application (application id 163).

image-20240202202526916

Application process supporting URL syntax​

The Rich Text Editor Pro integration with Oracle APEX prior to 22.2 requires creating a new application process enabling plug-in to clear its session state based on APEX URL syntax. The required application process is simple PL/SQL code executing the plug-in procedure manageClearCache.

The screen shot below presents the application process implementing the plug-in procedure.

image-20240203150830888

notice about the application process

If this process is not implemented, a developer might face unexpected value from previous CLOB handling. For example, a native APEX Form component created using the APEX page wizard clears the page session state whenever displaying the form creating new data.

Plug-in default settings​

The guidelines are created for the plug-in default settings, which means: