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 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