24.25 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

Table 24-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 CONTENT_CACHE_SIZE_TARGET CONTENT_CACHE_MAX_FILE_SIZE ENV_BANNER_COLOR ENV_BANNER_LABEL ENV_BANNER_POS ENV_BANNER_YN MAX_SESSION_IDLE_SEC MAX_SESSION_LENGTH_SEC MAX_WEBSERVICE_REQUESTS PATH_PREFIX QOS_MAX_WORKSPACE_REQUESTS QOS_MAX_SESSION_REQUESTS QOS_MAX_SESSION_KILL_TIMEOUT RM_CONSUMER_GROUP SESSION_TIMEOUT_WARNING_SEC WEBSERVICE_LOGGING 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' );
    COMMIT
END;