CACHE_PURGE_BY_APPLICATION Procedure

This procedure purges all cached pages and regions for a given application.

Syntax

APEX_UTIL.CACHE_PURGE_BY_APPLICATION (
    p_application  IN  NUMBER);

Parameters

Table: CACHE_PURGE_BY_APPLICATION Parameters describes the parameters available in the CACHE_PURGE_BY_APPLICATION procedure.

CACHE_PURGE_BY_APPLICATION Parameters

Parameter	Description
`p_application`	The identification number (ID) of the application.

Example

The following example demonstrates how to use the CACHE_PURGE_BY_APPLICATION procedure to purge all the cached pages and regions for the application currently executing.

BEGIN
    APEX_UTIL.CACHE_PURGE_BY_APPLICATION(p_application => :APP_ID);
END;