16.21 SET_WORKSPACE_PARAMETER

The SET_WORKSPACE_PARAMETER procedure sets the designated workspace parameter.

Syntax

SET_WORKSPACE_PARAMETER(
    p_workspace     IN VARCHAR2,
    p_parameter     IN VARCHAR2,
    p_value         IN VARCHAR2 );

Parameters

Table 16-21 SET_WORKSPACE_PARAMETER 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 for this workspace. Parameter names include:

  • ALLOW_HOSTNAMES

  • MAX_SESSION_IDLE_SEC

  • MAX_SESSION_LENGTH_SEC

  • QOS_MAX_WORKSPACE_REQUESTS

  • QOS_MAX_SESSION_REQUESTS

  • QOS_MAX_SESSION_KILL_TIMEOUT

  • RM_CONSUMER_GROUP

  • WORKSPACE_EMAIL_MAXIMUM

  • WORKSPACE_MAX_FILE_BYTES

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' );
END;

Parent topic: APEX_INSTANCE_ADMIN