Oracle Apex - Session (or application context)

> Integrated development environment (ide) > Oracle Apex

1 - About

A Session is created after :

Advertising

3 - Id

Each session is assigned a unique identifier. The Application Express engine uses this identifier (or session ID) to store and retrieve an application's working set of data (or session state) before and after each page view.

4 - Management

4.1 - Get

The session ID can be seen:

4.2 - Variable

4.2.1 - APP_SESSION

You can reference the session ID variable using the syntax:

  • Short substitution string: &APP_SESSION.
  • PL/SQL: V('APP_SESSION')
  • Bind variable: :APP_SESSION

Example with the Apex url

f?p=6000:6003:&APP_SESSION.::NO:6003:MY_ITEM:1234 
Advertising

4.2.2 - APP_SESSION_VISIBLE

APP_SESSION_VISIBLE enhance APP_SESSION by implementing also the zero session feature

4.3 - View

4.4 - Time out

Application Properties > Security > Session Timeout

4.5 - Api

4.5.1 - APEX_UTIL

See the APEX_UTIL package:

  • GET_SESSION_LANG Function
  • GET_SESSION_TERRITORY Function
  • GET_SESSION_TIME_ZONE Function

4.5.2 - APEX_CUSTOM_AUTH

You can use the APEX_CUSTOM_AUTH package to perform various operations related to session management.

4.6 - Purge

The ORACLE_APEX_PURGE_SESSIONS job (DBMS_SCHEDULER) purges sessions older than 12 hours (the default). This job runs every hour.

5 - Zero

The zero session ID function is in use in a public navigation context. See Zero Session Feature

Advertising