PURGE_CACHE Procedure

This procedure purges the region cache of the specified application, page, and region.

Syntax

APEX_REGION.PURGE_CACHE (
    p_application_id       IN NUMBER DEFAULT apex.g_flow_id,
    p_page_id              IN NUMBER DEFAULT NULL,
    p_region_id            IN NUMBER DEFAULT NULL,
    p_current_session_only IN BOOLEAN DEFAULT FALSE );

Parameters

Table 38-3 PURGE_CACHE Parameters

Parameter	Description
`p_application_id`	`ID` of the application where the region caches should be purged. Defaults to the current application.
`p_page_id`	`ID` of the page where the region caches should be purged. If no value is specified (default), all regions of the application are purged.
`p_region_id`	ID of a specific region on a page. If no value is specified, all regions of the specified page are purged.
`p_current_session_only`	Specify true if you only want to purge entries that where saved for the current session. Defaults to `FALSE`.

Example

This example purges session specific region cache for the whole application.

BEGIN
     APEX_REGION.PURGE_CACHE (
         p_current_session_only => true );
END;