ADD_SCHEMA Procedure

The 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: ADD_SCHEMA Parameters describes the parameters available in the ADD_SCHEMA procedure.

ADD_SCHEMA Parameters

Parameter	Description
`p_workspace`	The name of the workspace to which the schema mapping will be added.
`p_schema`	The schema to add to the schema to workspace mapping.

Example

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