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 |
---|---|
|
The case insensitive name of the application setting. An error raised if:
|
|
The value of the application setting. An error raised if:
|
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