Oracle Apex - Session state

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:

• Set Session State

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;