SET_SESSION_STATE Procedure

57.135 SET_SESSION_STATE Procedure

This procedure sets session state for a current Oracle APEX session.

Syntax

APEX_UTIL.SET_SESSION_STATE (
    p_name     IN    VARCHAR2 DEFAULT NULL,
    p_value    IN    VARCHAR2 DEFAULT NULL
    p_commit   IN    BOOLEAN  DEFAULT TRUE );

Parameters

Table 57-99 SET_SESSION_STATE Parameters

Parameter Description

p_name Name of the application-level or page-level item for which you are setting sessions state.

p_value Value of session state to set.

Parameter	Description
`p_name`	Name of the application-level or page-level item for which you are setting sessions state.
`p_value`	Value of session state to set.
`p_commit`	If TRUE (default), commit after modifying session state. If FALSE or if the existing value in session state equals `p_value`, no commit. This parameter is ignored when the application's Session State Changes attribute is set to `End Of Request`.

p_commit

If TRUE (default), commit after modifying session state.

If FALSE or if the existing value in session state equals p_value, no commit.

This parameter is ignored when the application's Session State Changes attribute is set to End Of Request.

Example

The following example uses the SET_SESSION_STATE procedure to change the value of the item my_item to myvalue in the current session.

BEGIN
    APEX_UTIL.SET_SESSION_STATE('my_item','myvalue');
END;