6.1 SET_VALUE Procedure

This procedure changes the application setting value in the current application.

Syntax

APEX_APP_SETTING.SET_VALUE(
    p_name         in varchar2,
    p_value        in varchar2 );

Parameters

Table 6-1 SET_VALUE Procedure 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.
p_value	The value of the application setting. An error raised if: The value is set to required, but null value passed. The valid values defined, but the value is not in one of the valid values.

Example

The following example shows how to use the SET_VALUE procedure to set the value of application setting ACCESS_CONTROL_ENABLED.

begin
    APEX_APP_SETTING.SET_VALUE(
        p_name  => 'ACCESS_CONTROL_ENABLED',
        p_value => 'Y' );
end;