About
Session state is a workspace that contains all variables with their values for one user.
Articles Related
Scope
Session state can be maintained:
- Per session (to maintain session state per session). The session ID locate the session state.
- Per user (to maintain session state for a user across sessions). The Application Express engine uses Oracle Apex - (Authentication|Identity) the key component.
See the “Maintain session state attribute” of the “Source” section of an item.
Management
View
Session state are variable.
API
You can use the APEX_UTIL package to get and set session state,
- FETCH_APP_ITEM Function. This function fetches session state for the current or specified application in the current or specified session of an item
- GET_NUMERIC_SESSION_STATE Function
- GET_SESSION_STATE. PLSQL/SQL. Shorthand, function V.
SET
With:
BEGIN
APEX_UTIL.SET_SESSION_STATE('my_item','myvalue');
END;
- the equal assignment
BEGIN
:MY_ITEM := :MY_SECOND_ITEM;
:MY_ITEM := 'myValue';
END;
- SELECT INTO statement
BEGIN
SELECT 1 INTO :MY_ITEM FROM DUAL;
END;