(APEX) Database objects
The summary below describes all database objects created after installing the sample application or installing the AOE as a standalone plug-in in an existing Oracle APEX application:
- column The plug-in describes whether an object is required for the manual installation
- column The sample application describes whether an object is required for the manual installation
| Object Name | Object Type | The plug-in | The sample application | Description |
|---|---|---|---|---|
| RESTful Service | Install script |  |
|
The RESTful Service is used to handle all AOE host server requests: load, create and update documents |
| AOE_FILES_DEFAULT | Table | |
|
The table is used as the default table to store document content when a developer doesn’t provide a custom table |
| AOE_FILES_DEFAULT_SEQ | Sequence | |
|
|
| BI_AOE_FILES_DEFAULT | Trigger | |
|
|
| AOE_FILES_CUSTOM | Table |  |
|
The plug-in sample application uses the table in order to showcase the usage of the plug-in attribute Settings \ Custom Table |
| BI_AOE_FILES_CUSTOM | Trigger | |
|
The trigger uses the same sequence as the trigger BI_AOE_FILES_DEFAULT |
| AOE_REST_LOGS | Table | |
|
The table is used by the plug-in REST service to log information about requests performed by the AOE host server to load and update document content. |
| AOE_REST_LOGS_SEQ | Sequence | |
|
|
| BI_AOE_REST_LOGS | Trigger | |
|
|
| AOE_SAMPLE_FILE_VERSIONS | Table | |
|
The plug-in sample application uses the table to showcase the plug-in callbacks' usage to implement custom document versioning |
| AOE_FILES_UPLOADED | Table | |
|
The table is used by the plug-in sample application to allow the uploading of end-user documents |
| AOE_FILES_UPLOADED_SEQ | Sequence | |
|
|
| BI_AOE_FILES_UPLOADED | Trigger | |
|
|
| PIP_CRYPTO | Package | |
|
The package is used by the plug-in to secure the plug-in access token |
| UC_UTF7 | Package | |
|
The package is used by the plug-in to decode document filenames from UTF7 to UTF8 |
| UC_PLUGIN_UTIL | Package | |
|
The package is used by the plug-in to evaluate APEX regions' read-only attribute |
| AOE_REST | Package | |
|
The package is used by the plug-in RESTful Service handlers to handle requests performed by the AOE host server |
| AOE_PLUGIN | Package | |
|
The plug-in package implements a region-type plug-in for the Oracle APEX |
| AOE_SAMPLE_APP_UTIL | Package | |
|
The package is used by the plug-in sample application to handle sample application page processes and implement custom callbacks |
| AOP_API21_PKG | Package | |
|
The APEX Office Print package is used by the plug-in sample application to showcase the integration of AOP and AOE |
| AOP_API_PKG | Synonym | |
|