GET_PARAMETER Function

The GET_PARAMETER 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

Table: GET_PARAMETER Parameters describes the parameters available in the GET_PARAMETER function.

Example

DECLARE L_VAL VARCHAR2(4000);
BEGIN
    L_VAL := 
APEX_INSTANCE_ADMIN.GET_PARAMETER('SMTP_HOST');
    HTP.P('The SMTP Host Setting Is: '||L_VAL);
END;