5.2 GET_VALUE Function

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

Syntax

APEX_APP_SETTING.GET_VALUE(
    p_name         IN VARCHAR2 ) RETURN VARCHAR2;

Parameters

Table 5-2 GET_VALUE Function Parameters

Parameters	Description
p_name	The case insensitive name of the application setting. An error raised if: Application Setting name does not exist. If build option, associated with application setting is disabled.

Example

The following example shows how to use 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;