5.1 GET_VALUE Function

This function gets 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 );

Parameters

Table 5-1 GET_VALUE Function Parameters

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

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;