SET_WORKSPACE_PARAMETER Procedure

32.34 SET_WORKSPACE_PARAMETER Procedure

This procedure sets the designated workspace parameter.

Syntax

APEX_INSTANCE_ADMIN.SET_WORKSPACE_PARAMETER (
    p_workspace     IN VARCHAR2,
    p_parameter     IN VARCHAR2,
    p_value         IN VARCHAR2 )

Parameters

Parameter	Description
`p_workspace`	The name of the workspace to which you are setting the workspace parameter.
`p_parameter`	The parameter name which overrides the instance parameter value of the same name for this workspace. See "Instance and Workspace Parameters" and "Workspace Parameters" in Available Parameter Values.
`p_value`	The parameter value.

Example

The following example demonstrates how to use the set_workspace_parameter procedure to restrict URLs for accessing applications in the HR workspace that have hr.example.com in the hostname or domain name.

BEGIN
  apex_instance_admin.set_workspace_parameter (
    p_workspace => 'HR',
    p_parameter => 'ALLOW_HOSTNAMES',
    p_value     => 'hr.example.com' );
  COMMIT;
END;