32.21 REMOVE_SCHEMA Procedure
Removes a workspace to schema mapping.
Syntax
APEX_INSTANCE_ADMIN.REMOVE_SCHEMA (
p_workspace IN VARCHAR2,
p_schema IN VARCHAR2 )
Parameters
Parameter | Description |
---|---|
p_workspace |
The name of the workspace from which the schema mapping is removed. |
p_schema |
The schema to remove from the schema to workspace mapping. |
Example
The following example demonstrates how to use the REMOVE_SCHEMA
procedure to remove the schema named Frank
from the MY_WORKSPACE
workspace to schema mapping.
BEGIN
APEX_INSTANCE_ADMIN.REMOVE_SCHEMA('MY_WORKSPACE','FRANK');
END;
Parent topic: APEX_INSTANCE_ADMIN