1. API Reference
  2. APEX_INSTANCE_ADMIN
  3. GET_WORKSPACE_PARAMETER Procedure

32.14 GET_WORKSPACE_PARAMETER Procedure

Gets the workspace parameter.

Syntax

APEX_INSTANCE_ADMIN.GET_WORKSPACE_PARAMETER (
    p_workspace     IN VARCHAR2,
    p_parameter     IN VARCHAR2 )

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:

  • ACCOUNT_LIFETIME_DAYS
  • ALLOW_HOSTNAMES
  • ENV_BANNER_COLOR
  • ENV_BANNER_LABEL
  • ENV_BANNER_POS
  • ENV_BANNER_YN
  • EXPIRE_FND_USER_ACCOUNTS
  • MAX_LOGIN_FAILURES
  • MAX_SESSION_IDLE_SEC
  • MAX_SESSION_LENGTH_SEC
  • MAX_WEBSERVICE_REQUESTS
  • QOS_MAX_SESSION_KILL_TIMEOUT
  • QOS_MAX_SESSION_REQUESTS
  • QOS_MAX_WORKSPACE_REQUESTS
  • RM_CONSUMER_GROUP
  • WEBSERVICE_LOGGING
  • 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