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.

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_apex220_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 Application wizard might finish with errors due to the plug-in access token type. Click Install Summary button to verify errors.

image-20240301171856535

If the only error is regarding Create access token type script, the installation is successful. See the sub section Compile access token type.

image-20240301171935664

Compile access token type

For some reason Oracle APEX display error when installing type with static and member methods. To be sure that the access token type is valid you can recompile the access token type.

Go to SQL Workshop \ SQL Commands

  1. Execute the following code ALTER TYPE UC_RTE_ACCESS_TOKEN COMPILE;
  2. Click Run button
  3. In the result, the SQL Commands should print Type altered.

image-20240301172048741

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