GET_NUMERIC_SESSION_STATE Function

53.59 GET_NUMERIC_SESSION_STATE Function

This function returns a numeric value for a numeric item. You can use this function in Oracle APEX 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.

Tip:

In the past, you could use this function in the following way: apex_util.get_numeric_session_state('P1_ITEM'). For enhanced query performance, use FAST DUAL functionality in the following SQL code syntax:

(select apex_util.get_numeric_session_state('P1_ITEM') from dual)

Syntax

APEX_UTIL.GET_NUMERIC_SESSION_STATE (
    p_item  IN VARCHAR2 )
RETURN NUMBER;

Parameters

Table 53-48 GET_NUMERIC_SESSION_STATE 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 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;