REMOVE_SCHEMA_EXCEPTION Procedure

32.22 REMOVE_SCHEMA_EXCEPTION Procedure

This procedure removes an exception that allows the assignment of a restricted schema to a given workspace.

Syntax

APEX_INSTANCE_ADMIN.REMOVE_SCHEMA_EXCEPTION (
    p_schema    IN VARCHAR2,
    p_workspace IN VARCHAR2 )

Parameter

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

Example

This example removes the exception that allows the assignment of schema HR to workspace HR_WORKSPACE.

BEGIN
    apex_instance_admin.remove_schema_exception (
        p_schema    => 'HR',
        p_workspace => 'HR_WORKSPACE' );
    commit;
END;