3.2 SET_VALUE Procedure
This procedure changes the application setting value in the current application. If the setting is subscribed from another app, this API will not update the setting value. If the setting is subscribed and p_raise_error
is set to TRUE
, this API raises an error.
Syntax
APEX_APP_SETTING.SET_VALUE (
p_name IN VARCHAR2,
p_value IN VARCHAR2,
p_raise_error IN BOOLEAN DEFAULT FALSE )
Parameters
Parameters | Description |
---|---|
p_name |
The case-insensitive name of the application setting. An error raises if:
|
p_value |
The value of the application setting. An error raises if:
|
p_raise_error |
If set to If set to In either case, this API never updates application setting values when an error occurs. |
Example
The following example uses the SET_VALUE
procedure to set the value of the 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