16.8 GET_WORKSPACE_PARAMETER

The GET_WORKSPACE_PARAMETER procedure gets the workspace parameter.

Syntax

get_workspace_parameter(
    p_workspace     IN VARCHAR2,
    p_parameter     IN VARCHAR2,

Parameters

Table 16-8 GET_WORKSPACE_PARAMETER Parameters

Parameter Description

p_workspace

The name of the workspace to which you are getting the workspace parameter.

p_parameter

The parameter name that overrides the instance parameter value of the same name 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

Example

The following example prints the value of ALLOW_HOSTNAMES for the HR workspace.

BEGIN
    DBMS_OUTPUT.PUT_LINE (
APEX_INSTANCE_ADMIN.GET_WORKSPACE_PARAMETER (
            p_workspace => 'HR',
            p_parameter => 'ALLOW_HOSTNAMES' ));
END;

Parent topic: APEX_INSTANCE_ADMIN