3.2 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,
    p_raise_error   IN BOOLEAN DEFAULT FALSE )

Parameters

Parameters	Description
p_name	The case-insensitive name of the application setting. An error raises if: the application setting name does not exist the build option associated with the application setting is disabled
p_value	The value of the application setting. An error raises if: the value is set to required, but a null value passes the valid values are defined, but the value is not in one of the valid values
p_raise_error	If set to TRUE, the procedure raises an error if the build option check failed.

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;