Oracle Apex - Session state

1 - About

Session state is a workspace that contains all variables with their values for one user.

3 - Scope

Session state can be maintained:

See the “Maintain session state attribute” of the “Source” section of an item.

4 - Management

4.1 - View

Session state are variable.

4.2 - 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.

4.2.1 - 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;


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap