This function returns the value for an item. You can use this function in your Oracle Application Express 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.
Syntax
APEX_UTIL.GET_SESSION_STATE (
p_item IN VARCHAR2)
RETURN VARCHAR2;
Parameters
Table 28-57 GET_SESSION_STATE Parameters
| Parameter | Description |
|---|---|
|
|
The case insensitive name of the item for which you want to have the session state fetched. |
Example
The following example shows how to use the GET_SESSION_STATE function to return 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;