18.4 CREATE_SCHEMA_EXCEPTION Procedure
This procedure creates an exception which allows assignment of a restricted schema to a specific workspace.
Syntax
APEX_INSTANCE_ADMIN.CREATE_SCHEMA_EXCEPTION (
p_schema IN VARCHAR2,
p_workspace IN VARCHAR2 );
Parameter
Table 18-4 CREATE_SCHEMA_EXCPETION Parameters
Parameter | Description |
---|---|
p_schema |
The schema. |
|
The workspace. |
Example
This example allows the assignment of restricted schema HR
to workspace HR_WORKSPACE
.
begin
apex_instance_admin.create_schema_exception (
p_schema => 'HR',
p_workspace => 'HR_WORKSPACE' );
commit;
end;
Parent topic: APEX_INSTANCE_ADMIN