Database Reference
In-Depth Information
:P1_ITEM_NAME := 'some value';
In PL/SQL, when in a stored procedure, you can use the
apex_util.set_session_state
procedure to set a value in session state:
apex_util.set_session_state( 'P1_ITEM_NAME', 'some
value');
The syntax to retrieve session state for an item varies according to where you're ref-
erencing the item.
In templates or regions, tabs, menus, or lists, use the following substitution-string
syntax (and don't forget the trailing dot!):
&P1_ITEM_NAME.
Use the following syntax in SQL statements:
:P1_ITEM_NAME
From PL/SQL, use one of the following two options depending on what type of
block or program unit you're in:
Anonymous PL/SQL block:
:P1_ITEM_NAME
PL/SQL Unit Called from APEX:
V('P1_ITEM_NAME')
Within conditions, use this syntax:
P1_ITEM_NAME
Note
The
V
function just mentioned is an APEX-provided function that retrieves the
session-state value of an APEX item. Exercise caution when using this function, be-
cause using it in a stored program unit could introduce performance issues.
Viewing Session State
To view session state, click the Session link on the Developer toolbar. You should see a
page like that in
Figure 6-43
.
Then use the Page, Find, and Views parameters to view
