20.16 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 20-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