1. API Reference
  2. APEX_INSTANCE_ADMIN
  3. GET_PARAMETER Function

32.12 GET_PARAMETER Function

This function retrieves the value of a parameter used in administering a runtime environment.

Syntax

APEX_INSTANCE_ADMIN.GET_PARAMETER (
    p_parameter     IN VARCHAR2 )
RETURN VARCHAR2;

Parameters

Parameter Description
p_parameter

The instance parameter to be retrieved.

See Available Parameter Values.

Example

The following example demonstrates how to use the GET_PARAMETER function to retrieve the SMTP_HOST_ADDRESS parameter currently defined for an APEX instance. 

DECLARE
    L_VAL VARCHAR2(4000);
BEGIN
    L_VAL :=APEX_INSTANCE_ADMIN.GET_PARAMETER('SMTP_HOST_ADDRESS');
    DBMS_OUTPUT.PUT_LINE('The SMTP Host Setting Is: '||L_VAL);
END;

Parent topic: APEX_INSTANCE_ADMIN