20.8 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 20-6 GET_PARAMETER Parameters
Parameter | Description |
---|---|
|
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 Oracle Application Express 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