50.4 GET_CACHE_DATE Function

This function returns the date and time a specified region was cached either for the user issuing the call, or for all users if the page was not set to be cached by user.

Syntax

APEX_REGION.GET_CACHE_DATE (
    p_application_id     IN   NUMBER,
    p_page_id            IN   NUMBER,
    p_static_id          IN   VARCHAR2 )  
    RETURN DATE;

Parameters

Parameter	Description
p_application_id	The identification number (ID) of the application.
p_page_id	The page number (ID).
p_static_id	The region Static ID.

Examples

The following example demonstrates how to use the GET_CACHE_DATE function to retrieve the cache date and time for the region Static ID cached-region on page 13 of the currently executing application. If the region is cached, the cache date and time is output using the HTP package. The region could have been cached either by the user issuing the call, or for all users if the page was not to be cached by user.

declare
    l_cache_date date;
begin
    l_cache_date := apex_region.get_cache_date (
                        p_application_id => :APP_ID,
                        p_page_id        => 13,
                        p_static_id      => 'cached-region');
    if l_cache_date is not null then
        sys.htp.p('Cached on ' || to_char(l_cache_date, 'DD-MON-YY HH24:MI:SS'));
    end if;
end;