REMOVE_SCHEMA_EXCEPTIONS Procedure

20.17 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

Table 20-14 REMOVE_SCHEMA_EXCEPTIONS 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;