32.21 REMOVE_SCHEMA Procedure
This REMOVE_SCHEMA
procedure removes a workspace to schema mapping.
Syntax
APEX_INSTANCE_ADMIN.REMOVE_SCHEMA(
p_workspace IN VARCHAR2,
p_schema IN VARCHAR2);
Parameters
Table 32-10 REMOVE_SCHEMA Parameters
Parameter | Description |
---|---|
|
The name of the workspace from which the schema mapping is removed. |
|
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