17.9 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 17-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;