REMOVE_SCHEMA_EXCEPTIONS Procedure

32.23 REMOVE_SCHEMA_EXCEPTIONS Procedure

This procedure removes all exceptions that allow the assignment of a given schema to workspaces.

Syntax

APEX_INSTANCE_ADMIN.REMOVE_SCHEMA_EXCEPTIONS (
      p_schema IN VARCHAR2 )

Parameter

Parameter	Description
`p_schema`	The schema.

Example

This example removes all exceptions that allow the assignment of the HR schema to workspaces.

BEGIN
    apex_instance_admin.remove_schema_exceptions (
            p_schema => 'HR' );
    COMMIT;
END;