Skip to main content

Database objects

Database objects listed below are created after installing the plug-in using the sample application installation file or using manual DDL scripts.

The column

  • Sample application - describes whether an object is part of the plug-in sample application supporting objects
  • DDL Script - describes whether an object is required for manual installing the plug-in.

Overview​

Object nameObject typeDDL ScriptSample application
UC_PLUGINSPRO_LICENSETableicon_check_16pxicon_check_16px
UC_FROALA_SAMPLE_BLOBSTableicon_check_16pxicon_check_16px
UC_FROALA_SAMPLE_CLOBSTableicon_notchecked_16pxicon_check_16px
UC_FROALA_SAMPLE_CLOB_BLOBSTableicon_notchecked_16pxicon_check_16px
UC_FROALA_SAMPLE_BLOBS_SEQSequenceicon_check_16pxicon_check_16px
UC_FROALA_SAMPLE_CLOBS_SEQSequenceicon_notchecked_16pxicon_check_16px
UC_FROALA_SAMPLE_CLOB_BLOBS_SEQSequenceicon_notchecked_16pxicon_check_16px
BI_UC_FROALA_SAMPLE_BLOBSTriggericon_check_16pxicon_check_16px
BI_UC_FROALA_SAMPLE_CLOBSTriggericon_notchecked_16pxicon_check_16px
UC_FROALA_SAMPLE_CLOB_BLOBS_FKConstrainticon_notchecked_16pxicon_check_16px
UC_FROALA_SAMPLE_CLOB_BLOBS_FK2Constrainticon_notchecked_16pxicon_check_16px
UC_CRYPTOPackageicon_check_16pxicon_check_16px
UC_PLUGINSPROPackageicon_check_16pxicon_check_16px
UC_FROALA_SETTINGSPackageicon_check_16pxicon_check_16px
UC_FROALA_RTEPackageicon_check_16pxicon_check_16px
UC_FROALA_SAMPLE_RESTPackageicon_check_16pxicon_check_16px
UC_FROALA_SAMPLE_APPPackageicon_notchecked_16pxicon_check_16px
UC_RTE_ACCESS_TOKENTypeicon_check_16pxicon_check_16px
RESTful service moduleScripticon_check_16pxicon_check_16px

Tables​

UC_PLUGINSPRO_LICENSE​

The table stores information about plug-ins pro licenses activated.

UC_FROALA_SAMPLE_BLOBS​

The table stores uploaded images using the plug-in RESTful service.

UC_FROALA_SAMPLE_CLOBS​

The table stores the sample application CLOB values modified with the plug-in.

UC_FROALA_SAMPLE_CLOB_BLOBS​

The table stores uploaded image BLOB in the context of saved rich text CLOB.

Sequences​

UC_FROALA_SAMPLE_BLOBS_SEQ​

Required by the table UC_FROALA_SAMPLE_BLOBS.

UC_FROALA_SAMPLE_CLOBS_SEQ​

Required by the table UC_FROALA_SAMPLE_CLOBS.

UC_FROALA_SAMPLE_CLOB_BLOBS_SEQ​

Required by the table UC_FROALA_SAMPLE_CLOB_BLOBS

Constraints​

UC_FROALA_SAMPLE_CLOB_BLOBS_FK​

Defines foreign key between UC_FROALA_SAMPLE_CLOB_BLOBS.BLOB_ID and UC_FROALA_SAMPLE_BLOBS.ID

UC_FROALA_SAMPLE_CLOB_BLOBS_FK2​

Defines foreign key between UC_FROALA_SAMPLE_CLOB_BLOBS.CLOB_ID and UC_FROALA_SAMPLE_CLOBS.ID

Triggers​

BI_UC_FROALA_SAMPLE_BLOBS​

Required by the table UC_FROALA_SAMPLE_BLOBS.

BI_UC_FROALA_SAMPLE_CLOBS​

Required by the table UC_FROALA_SAMPLE_CLOBS.

Packages​

UC_CRYPTO​

The package is used to secure the access token.

UC_PLUGINSPRO​

The package is used to evaluate the plug-in license.

UC_FROALA_SETTINGS​

The package is used to configure the plug-in access token salt.

UC_FROALA_RTE​

This package implements an item-type plug-in for Oracle APEX and the plug-in PL/SQL API.

UC_FROALA_SAMPLE_REST​

The package is used by the RESTful service module to handle images.

UC_FROALA_SAMPLE_APP​

The package is used by the plug-in sample application.

Types​

UC_RTE_ACCESS_TOKEN​

The type defines decoded access token.

Scripts​

RESTful service module​

The script creates the plug-in RESTful service module handling images.

Learn more in The plug-in \ Image handling.