FETCH_APP_ITEM Function

58.31 FETCH_APP_ITEM Function

This function fetches session state for the current or specified application in the current or specified session.

Syntax

APEX_UTIL.FETCH_APP_ITEM (
    p_item    IN VARCHAR2,
    p_app     IN NUMBER DEFAULT NULL,
    p_session IN NUMBER DEFAULT NULL )
RETURN VARCHAR2;

Parameters

Parameter	Description
`p_item`	The name of an application-level item (not a page item) whose current value is to be fetched.
`p_app`	The ID of the application that owns the item (leave null for the current application).
`p_session`	The session ID from which to obtain the value (leave null for the current session).

Example

The following example shows how to use the FETCH_APP_ITEM function to obtain the value of the application item 'F300_NAME' in application 300. As no value is passed for p_session, this defaults to the current session state value.

DECLARE
    VAL VARCHAR2(30);
BEGIN
    VAL := APEX_UTIL.FETCH_APP_ITEM(
        p_item => 'F300_NAME',
        p_app => 300);
END;

Parent topic: APEX_UTIL