36.55 GET_NUMERIC_SESSION_STATE Function
This function returns a numeric value for a numeric item. You can use this function in Oracle Application Express applications wherever you can use PL/SQL or SQL. You can also use the shorthand, function NV
, in place of APEX_UTIL
.GET_NUMERIC_SESSION_STATE
.
Syntax
APEX_UTIL.GET_NUMERIC_SESSION_STATE (
p_item IN VARCHAR2)
RETURN NUMBER;
Parameters
Table 36-49 GET_NUMERIC_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 function to return the numeric value stored in session state for the item 'my_item
'.
DECLARE
l_item_value NUMBER;
BEGIN
l_item_value := APEX_UTIL.GET_NUMERIC_SESSION_STATE('my_item');
END;
See Also:
Parent topic: APEX_UTIL