GET_SESSION_STATE Function

48.67 GET_SESSION_STATE Function

This function returns the value for an item. You can use this function in your Oracle APEX applications wherever you can use PL/SQL or SQL. You can also use the shorthand function V in place of APEX_UTIL.GET_SESSION_STATE.

Tip:

In the past, you could use this function in the following way: apex_util.get_session_state('P1_ITEM'). For enhanced query performance, use FAST DUAL functionality in the following SQL code syntax:

(select apex_util.get_session_state('P1_ITEM') from dual))

Syntax

APEX_UTIL.GET_SESSION_STATE (
    p_item  IN VARCHAR2 )
RETURN VARCHAR2;

Parameters

Table 48-59 GET_SESSION_STATE Parameters

Parameter	Description
`p_item`	The case insensitive name of the item for which you want to have the session state fetched.

Example

The following example returns the value stored in session state for the item my_item.

DECLARE
    l_item_value  VARCHAR2(255);
BEGIN
    l_item_value := APEX_UTIL.GET_SESSION_STATE('my_item');
END;