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;

Parent topic: APEX_APP_SETTING