Skip to main content

Oracle APEX 22.2 onwards

This document covers step-by-step instructions for installing the plug-in sample application in Oracle APEX versions 22.2 and above. For Oracle APEX version priot to 22.2 please follow instructions described here.

Below the supported floor

Rich Text Editor Pro 26.1.0 requires Oracle Database 19c and Oracle APEX 24.2 or above. The app_apex222_ export documented on this page is for earlier Oracle APEX releases. It is shipped unchanged, is outside those pre-requisites, and does not contain the sample application improvements released in 26.1.0.

On Oracle APEX 24.2 and above, install the current sample application instead.

Installation pre-requisites​

  • Oracle Database 12c or above
  • Oracle Application Express (APEX) 22.2 or above installed
  • the schema implementing an application where the plug-in will be installed must be REST enabled.
  • the plug-in bundle is downloaded in extracted on the desktop

Import Sample Application​

Log into your Oracle APEX application builder and click Import button.

image-20240301171211092

In the Oracle APEX import wizard:

  1. Go to extracted the plug-in zip archive
  2. Select file app_apex222_unitedcodes_rich_text_editor_pro.sql from extracted plug-in zip archive
  3. Click Next Button

image-20240301171241707

In the Import (File Import Configuration) wizard click Next button.

image-20240301171312992

In the Install Database Application (Install) wizard:

  1. (Optional) Set Parsing Schema
  2. (Optional) Set Install As Application
  3. Click Install Application button

image-20240301171412651

Oracle APEX import wizard is installing the sample application. Don't close the browser tab and wait until the process is finished.

image-20240301171439374

Once, the sample application is created, the Install Application wizard starts. Do the following:

  1. Set Install Supporting Objects to Yes
  2. (Optional) Preview Installation Script
  3. Click Next button

image-20240301171605512

In the Install Application (Validations) wizardc lick Next button.

image-20240301171701201

In the Install Application (Confirmation) wizard click Install button

image-20240301171740744

The Install Summary should report every script as successful.

Installations before plug-in release 26.1.0

Up to release 24.1 this wizard finished with one error, on the Create access token type script, and the type body had to be recompiled by hand with ALTER TYPE UC_RTE_ACCESS_TOKEN COMPILE;.

The cause was the install order: the type body reads UC_FROALA_SETTINGS.g_froala_access_token, but the package was created after the type, so the body compiled against something that did not exist yet. Release 26.1.0 creates the package first, and the error no longer occurs.

Activate license​

Once the sample application is installed, the plug-in license must be activated. Otherwise, the plug-in will raise PL/SQL error UC-20011: The plug-in license not found. Read on how to activate the plug-in license here.

Run sampel application​

Navigate ro installed sample application and click Run Application.

image-20240301172259626

From the home page you can easily test most plug-in features using exposed buttons and settings region.

image-20240301172346179

Click the button Sample Application Checks in application navigation bar to open dialog showing sample application CLOB support status.

image-20240301172419133