Oracle Apex - Session state

Card Puncher Data Processing

About

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

Scope

Session state can be maintained:

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

Oracle Apex Session State Scope

Management

View

Session state are variable.

Apex Session State Feedback

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;





Discover More
Oracle Apex Page Type
Oracle Apex - (Application) page

A page is the basic building block of an database application. Application pages share a common: session state and authentication. Individual pages are organized using containers called regions....
Card Puncher Data Processing
Oracle Apex - (Authentication|Identity)

This page makes part of the security theme and talks authentication implementation in Apex. Once a user has been identified, the Application Express engine keeps track of each user by setting: ...
Oracle Apex Items Type
Oracle Apex - (Form|Page) (Field|Item)

An item (also called a field) is a HTML form elements such as text fields, select lists, and check boxes. Every item has a session state value that can be referenced by a variable. Item names...
Apex Substitution Variable
Oracle Apex - (Variable|State Value|Flag)

Variable in Apex. substitution string where: #VARIABLE# is a substitution string in Page template &VARIABLE. is a substitution string :VARIABLE is a bind variable V is a shorthand function...
Card Puncher Data Processing
Oracle Apex - Application items

Application items are not associated with a page but with an application and therefore have no user interface properties. You can use an application item as a global variable. Shares session state...
Card Puncher Data Processing
Oracle Apex - Bind Variable

Bind variables syntax can be used for SQL or PL/SQL to reference session state of a specified item. Items Bind...
Card Puncher Data Processing
Oracle Apex - Item (Initialization | Evaluation | Populating | Computation)

Content on the initialization process of the value of an item (ie session state) The Sequence attribute of an item determines the order of evaluation. See also Simple form populating Page...
Card Puncher Data Processing
Oracle Apex - Page (Accept|Processing|Submit|Controller)

“Accept page” performs any computations, validations, processes, and branching. When you submit a page, the Application Express engine is running Accept Page or performing page processing during which...
Card Puncher Data Processing
Oracle Apex - Public Navigation (Page and user)

The public navigation mechanism in Apex. A public navigation means that: the user is a public user (not authenticated), the target page is a public page in the current application This prerequisites...
Card Puncher Data Processing
Oracle Apex - Tabular Form

A form that performs update, insert, and delete operations on multiple rows in a database table. A tabular form is rendered as a report having updatable columns shown using various form elements. ...



Share this page:
Follow us:
Task Runner