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
Table 32-4 GET_PARAMETER Parameters
Parameter | Description |
---|---|
p_parameter |
The instance parameter to be retrieved. |
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