This function returns the date and time a specified application page was cached either for the user issuing the call, or for all users if the page was not set to be cached by user.
APEX_UTIL.CACHE_GET_DATE_OF_PAGE_CACHE ( p_application IN NUMBER, p_page IN NUMBER) RETURN DATE;
Table 28-1 CACHE_GET_DATE_OF_PAGE_CACHE Parameters
The identification number (ID) of the application.
The page number (ID).
The following example demonstrates how to use the
CACHE_GET_DATE_OF_PAGE_CACHE function to retrieve the cache date and time for page 9 of the currently executing application. If page 9 has been cached, the cache date and time is output using the HTP package. The page could have been cached either by the user issuing the call, or for all users if the page was not to be cached by the user.
DECLARE l_cache_date DATE DEFAULT NULL; BEGIN l_cache_date := APEX_UTIL.CACHE_GET_DATE_OF_PAGE_CACHE( p_application => :APP_ID, p_page => 9); IF l_cache_date IS NOT NULL THEN HTP.P('Cached on ' || TO_CHAR(l_cache_date, 'DD-MON-YY HH24:MI:SS')); END IF; END;