Referencing Session State

You can reference item values stored in session state in regions, computations, processes, validations, and branches. An item can be a field, a text area, a password, a select list, or a check box. Table: Syntax for Referencing Item Values describes the supported syntax for referencing item values.

Syntax for Referencing Item Values

Type	Syntax	Description
SQL	`:MY_ITEM`	Use standard bind variable syntax for items whose names are no longer than 30 characters. Use this syntax for references within a SQL query and within PL/SQL.
PL/SQL	`V('MY_ITEM')`	Use PL/SQL syntax to reference an item value using the `V` function. See Also: Oracle Application Express API Reference
PL/SQL	`NV('MY_NUMERIC_ITEM')`	Use standard PL/SQL syntax referencing the numeric item value using the `NV` function. See Also: Oracle Application Express API Reference
Static text (exact)	`&MY_ITEM.`	For static text or an exact substitution use the convention `&ITEM_NAME` followed by a period (.), for example: `&MY_ITEM.`