22 APEX_INSTANCE_ADMIN
The APEX_INSTANCE_ADMIN
package provides utilities for managing an Oracle APEX runtime environment.
Use the APEX_INSTANCE_ADMIN
package to get and set email settings, Oracle Wallet settings, report printing settings, and to manage schema to workspace mappings.
APEX_INSTANCE_ADMIN
can be executed by the SYS
or SYSTEM
database users and any database user granted the role APEX_ADMINISTRATOR_ROLE
.
- Available Parameter Values
- ADD_SCHEMA Procedure
- ADD_WEB_ENTRY_POINT Procedure
- ADD_WORKSPACE Procedure
- CREATE_SCHEMA_EXCEPTION Procedure
- DB_SIGNATURE Function
- FREE_WORKSPACE_APP_IDS Procedure
- GET_PARAMETER Function
- GET_SCHEMAS Function
- GET_WORKSPACE_PARAMETER
- IS_DB_SIGNATURE_VALID Function
- REMOVE_APPLICATION Procedure
- REMOVE_SAVED_REPORT Procedure
- REMOVE_SAVED_REPORTS Procedure
- REMOVE_SCHEMA Procedure
- REMOVE_SCHEMA_EXCEPTION Procedure
- REMOVE_SCHEMA_EXCEPTIONS Procedure
- REMOVE_SUBSCRIPTION Procedure
- REMOVE_WEB_ENTRY_POINT Procedure
- REMOVE_WORKSPACE Procedure
- REMOVE_WORKSPACE_EXCEPTIONS Procedure
- RESERVE_WORKSPACE_APP_IDS Procedure
- RESTRICT_SCHEMA Procedure
- SET_LOG_SWITCH_INTERVAL Procedure
- SET_WORKSPACE_PARAMETER
- SET_PARAMETER Procedure
- SET_WORKSPACE_CONSUMER_GROUP Procedure
- TRUNCATE_LOG Procedure
- UNRESTRICT_SCHEMA Procedure
- VALIDATE_EMAIL_CONFIG Procedure