Table of Contents
Oracle Application Express API Reference
APEX_APPLICATIONAPEX_ACLAPEX_APPLICATION_INSTALLAPEX_AUTHENTICATIONAPEX_AUTHORIZATIONAPEX_APP_SETTINGAPEX_COLLECTIONAPEX_CREDENTIALAPEX_CSSAPEX_CUSTOM_AUTHAPEX_DEBUGAPEX_ESCAPEAPEX_ERRORAPEX_EXECAPEX_EXPORTAPEX_INSTANCE_ADMINAPEX_IRAPEX_ITEMAPEX_JAVASCRIPTAPEX_JSONAPEX_JWTAPEX_LANGAPEX_LDAPAPEX_MAILAPEX_PKG_APP_INSTALLAPEX_PAGEAPEX_PLUGINAPEX_PLUGIN_UTILAPEX_REGIONAPEX_SESSIONAPEX_SPATIALAPEX_STRINGAPEX_THEMEAPEX_UI_DEFAULT_UPDATEAPEX_UTILAPEX_WEB_SERVICEAPEX_ZIPJavaScript APIsapex namespaceapex.da namespaceapex.debug namespaceapex.event namespaceapex.itemapex.lang namespaceapex.message namespaceapex.navigation namespaceapex.page namespaceapex.regionapex.server namespaceapex.storage namespaceapex.util namespaceapex.widget namespaceEventsNon-namespace JavaScript APIsUsing REST Administration Interface APIThe ADD_SCHEMA procedure adds a schema to a workspace to schema mapping.
Syntax
APEX_INSTANCE_ADMIN.ADD_SCHEMA(
p_workspace IN VARCHAR2,
p_schema IN VARCHAR2);
Parameters
Table 16-2 ADD_SCHEMA Parameters
| Parameter | Description |
|---|---|
|
|
The name of the workspace to which the schema mapping is added. |
|
|
The schema to add to the schema to workspace mapping. |
Example
The following example demonstrates how to use the ADD_SCHEMA procedure to map a schema mapped to a workspace.
BEGIN
APEX_INSTANCE_ADMIN.ADD_SCHEMA('MY_WORKSPACE','FRANK');
END;
Parent topic: APEX_INSTANCE_ADMIN