7.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 7-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;

Parent topic: APEX_APP_SETTING