43.4 CACHE_PURGE_BY_PAGE Procedure
This procedure purges the cache for a given application and page. If the page itself is not cached but contains one or more cached regions, then the cache for these is also purged.
Syntax
APEX_UTIL.CACHE_PURGE_BY_PAGE (
p_application IN NUMBER,
p_page IN NUMBER,
p_user_name IN VARCHAR2 DEFAULT NULL);
Parameters
Table 43-4 CACHE_PURGE_BY_PAGE Parameters
Parameter | Description |
---|---|
|
The identification number (ID) of the application. |
|
The page number (ID). |
|
The user associated with cached pages and regions. |
Example
The following example demonstrates how to use the CACHE_PURGE_BY_PAGE
procedure to purge the cache for page 9 of the application currently executing. Additionally, if the p_user_name
parameter is supplied, this procedure would be further restricted by a specific users cache (only relevant if the cache is set to be by user).
BEGIN
APEX_UTIL.CACHE_PURGE_BY_PAGE(
p_application => :APP_ID,
p_page => 9);
END;
Parent topic: APEX_UTIL