59.70 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:
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
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;
Parent topic: APEX_UTIL