REMOVE_SCHEMA Procedure

This REMOVE_SCHEMA procedure removes a schema from a workspace to schema mapping.

Syntax

APEX_INSTANCE_ADMIN.REMOVE_SCHEMA(
    p_workspace     IN VARCHAR2
    p_schema        IN VARCHAR2);

Parameters

Table: REMOVE_SCHEMA Parameters describes the parameters available in the REMOVE_SCHEMA procedure.

REMOVE_SCHEMA Parameters

Parameter	Description
`p_workspace`	The name of the workspace from which the schema mapping will be removed.
`p_schema`	The schema to remove from the schema to workspace mapping.

Example

BEGIN
APEX_INSTANCE_ADMIN.REMOVE_SCHEMA
('MY_WORKSPACE','FRANK');
END;