CREATE_SCHEMA_EXCEPTION Procedure

20.5 CREATE_SCHEMA_EXCEPTION Procedure

This procedure creates an exception which allows assignment of a restricted schema to a specific workspace.

Syntax

APEX_INSTANCE_ADMIN.CREATE_SCHEMA_EXCEPTION (
    p_schema    IN VARCHAR2,
    p_workspace IN VARCHAR2 );

Parameter

Table 20-4 CREATE_SCHEMA_EXCPETION Parameters

Parameter	Description
p_schema	The schema.
`p_workspace`	The workspace.

Example

This example allows the assignment of restricted schema HR to workspace HR_WORKSPACE.

begin
    apex_instance_admin.create_schema_exception (
        p_schema    => 'HR',
        p_workspace => 'HR_WORKSPACE' );
    commit;
end;