3.1 GET_VALUE Function

This function retrieves the application setting value in the current application.

Syntax

APEX_APP_SETTING.GET_VALUE (
    p_name          IN VARCHAR2
    p_raise_error   IN BOOLEAN DEFAULT FALSE )
RETURN VARCHAR2;

Parameters

Parameters	Description
p_name	The case insensitive name of the application setting. An error raises if: the application setting name does not exist the build option associated with the application setting is disabled
p_raise_error	If TRUE, the procedure raises an error if an application setting with a passed name does not exist.

Example

The following example uses the GET_VALUE function to retrieve the value of application setting ACCESS_CONTROL_ENABLED.

DECLARE
    l_value varchar2(4000);
BEGIN
    l_value := APEX_APP_SETTING.GET_VALUE( p_name => 'ACCESS_CONTROL_ENABLED');
END;