Skip to main content

Install using the DDL script

The manual installation is the best way to start using the plug-in in an existing Oracle APEX application. The manual installation creates only mandatory database objects required to use the plug-in successfully.

Database objects​

After installing the plug-in with DDL script the database objects described in the table below will be created.

Object nameObject type
UC_PLUGINSPRO_LICENSETable
UC_FROALA_SAMPLE_BLOBSTable
UC_FROALA_SAMPLE_BLOBS_SEQSequence
BI_UC_FROALA_SAMPLE_BLOBSTrigger
UC_CRYPTOPackage
UC_PLUGINSPROPackage
UC_FROALA_SETTINGSPackage
UC_FROALA_RTEPackage
UC_FROALA_SAMPLE_RESTPackage
UC_FROALA_SAMPLE_APPPackage
UC_RTE_ACCESS_TOKENType
RESTful service moduleScript

Steps​

Import & run the DDL script creating database objects​

  1. From the APEX Application Builder, in the top menu bar, select SQL Workshop and then SQL Scripts

    image-20230228162229136

  2. Click the Upload button

    image-20230228162544172

  3. In the Upload Script dialog, click on Choose File and select the file: ddl_uc_rte_manual_install.sql

  4. Click the Upload button

    image-20230228162726558

  5. After successfully uploading the script, click the Run button.

    image-20230228162840714

  6. Click the Run Now button on the confirmation screen.

    image-20230228163010859

  7. Examine the installation summary - the script should not raise any errors

    image-20230228163320795

info

Once the required database objects are created, please proceed to the next step Import & install the item plug-in.

Import & install the item plug-in​

  1. Go to the APEX Application Builder home page.

  2. Select the application where you want to use United Codes Rich Text Editor Pro

  3. Go to Export / Import

    image-20230228164108023

  4. Click Import tile

    image-20230228164225266

  5. Click on the Drag and Drop

  6. Select the plug-in installation file apex222_item_type_plugin_unitedcodes_froala_rte.sql`

  7. Set File Type to Plug-in

  8. Click Next button

    image-20230228164326571

  9. Wait until the file is imported successfully

    image-20230228164345171

  10. Click the Next button

    image-20230228164417973

  11. Check if the selected application is valid

  12. Click the Install Plug-in button

    image-20230228164518908

After successful installation, the plug-in application component settings must be checked and eventually updated. Fill in the correct values if you know what you are doing.

image-20230918191003016

info

The plug-in application component settings use Oracle APEX help available after clicking the question mark icon.

(optional) Install the supporting plug-ins​

The supporting dynamic action and process plug-in are not required to use the core item plug-in but deliver a convenient way to customize the plug-in editor or handle CLOB value.

To install the supporting plug-in, please follow the steps described in the section Install the plug-in an existing application for files:

  • apex222_dynamic_action_plugin_unitedcodes_froala_rte_da_conf.sql
  • apex222_process_type_plugin_unitedcodes_froala_rte_process.sql
learn more

The supporting dynamic action and process plug-ins are described

Learn more about the supporting dynamic action and process plug-in in the section Supporting plug-ins.