ADD_WORKSPACE Procedure

The ADD_WORKSPACE procedure adds a workspace to an Application Express Instance.

Syntax

APEX_INSTANCE_ADMIN.ADD_WORKSPACE(
    p_workspace_id        IN NUMBER DEFAULT NULL,
    p_workspace           IN VARCHAR2,
    p_primary_schema      IN VARCHAR2,
    p_additional_schemas  IN VARCHAR2 );

Parameters

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

ADD_WORKSPACE Parameters

Parameter	Description
`p_workspace_id`	The ID to uniquely identify the workspace in an Application Express instance. This may be left null and a new unique ID will be assigned.
`p_workspace`	The name of the workspace to be added.
`p_primary_schema`	The primary database schema to associate with the new workspace.
`p_additional_schemas`	A colon delimited list of additional schemas to associate with this workspace.

Example

The following example demonstrates how to use the ADD_WORKSPACE procedure to add a new workspace named MY_WORKSPACE using the primary schema, SCOTT, along with additional schema mappings for HR and OE.

BEGIN
    APEX_INSTANCE_ADMIN.ADD_WORKSPACE(8675309,'MY_WORKSPACE','SCOTT','HR:OE');
END;