29.2 PURGE_CACHE Procedure

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

Syntax

PROCEDURE 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 29-1 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 (which is the 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;

Parent topic: APEX_REGION