Oracle APEX 24.2 onwards
This document covers step-by-step instructions for installing the plug-in sample application in Oracle APEX versions 24.2 and above. For earlier Oracle APEX versions follow the instructions for Oracle APEX 22.2 onwards or Oracle APEX 19.2 onwards.
The plug-in bundle contains three sample application exports. Use the one matching your Oracle APEX version - on 24.2 and above that is app_unitedcodes_rich_text_editor_pro.sql, the export without a version prefix.
The app_apex192_ and app_apex222_ exports are kept for older Oracle APEX releases and are frozen. They do not contain the sample application improvements released in 26.1.0.
Installation pre-requisites
- Oracle Database 19c or above
- Oracle Application Express (APEX) 24.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 and extracted on the desktop
Import Sample Application
Log into your Oracle APEX application builder and click the Import button.
In the Oracle APEX import wizard:
- Go to the extracted plug-in zip archive
- Select the file
app_unitedcodes_rich_text_editor_pro.sql - Click Next
In the Import (File Import Configuration) wizard click Next.
In the Install Database Application (Install) wizard:
- (Optional) Set Parsing Schema
- (Optional) Set Install As Application
- Click Install Application
Oracle APEX is installing the sample application. Do not close the browser tab and wait until the process is finished.
Once the sample application is created, the Install Application wizard starts. Do the following:
- Set Install Supporting Objects to Yes
- (Optional) Preview the installation script
- Click Next
In the Install Application (Validations) wizard click Next.
In the Install Application (Confirmation) wizard click Install.
The Install Summary should report every script as successful, with no statements in error.
Supporting objects
The supporting objects install creates the following, in this order:
| # | Script | Creates |
|---|---|---|
| 1 | Create Package UC_CRYPTO | UC_CRYPTO |
| 2 | Create plug-in license table | UC_PLUGINSPRO_LICENSE |
| 3 | Create license package | UC_PLUGINSPRO |
| 4 | Create package UC_FROALA_SETTINGS | UC_FROALA_SETTINGS |
| 5 | Create access token type | UC_RTE_ACCESS_TOKEN |
| 6 | Create sequences for CLOBs and BLOBs | three sequences |
| 7 | Create tables for CLOBs and BLOBs | UC_FROALA_SAMPLE_BLOBS, UC_FROALA_SAMPLE_CLOBS, UC_FROALA_SAMPLE_CLOB_BLOBS |
| 8 | Create Sample Languages | UC_FROALA_SAMPLE_LANGUAGES |
| 9 | Create triggers for CLOBs and BLOBs | the row triggers |
| 10 | Create package UC_FROALA_RTE | UC_FROALA_RTE |
| 11 | Create supporting package UC_FROALA_SAMPLE_REST | UC_FROALA_SAMPLE_REST |
| 12 | Create supporting package UC_FROALA_SAMPLE_APP | UC_FROALA_SAMPLE_APP |
| 13 | Sample Data Cleanup | UC_FROALA_SAMPLE_CLEANUP |
| 14 | Create REST module | the RESTful service module |
The scripts are re-runnable: an existing table or sequence is left untouched, so re-installing the supporting objects over an earlier installation cannot discard data.
Activate license
Once the sample application is installed, the plug-in license must be activated. Otherwise the plug-in raises the PL/SQL error UC-20011: The plug-in license not found. Read how to activate the plug-in license here.
Run sample application
Navigate to the installed sample application and click Run Application.
From the home page you can test most plug-in features using the exposed buttons and the settings region.
Click the Sample Application Checks button in the application navigation bar to open a dialog showing the sample application CLOB support status.
The sample application demonstrates how the plug-in is used. It seeds demonstration data for the examples that need it, so it is not intended to be exposed to the public internet. If you publish it, put it behind authentication or restrict access at your web tier.