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
Table 16-13 REMOVE_SCHEMA_EXCEPTION Parameters
Parameter | Description |
---|---|
|
The schema. |
|
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;
Parent topic: APEX_INSTANCE_ADMIN