39.7 PURGE_CACHE Procedure

This procedure purges the cache of the specified application, page, and region for the specified user. If the user is not specified, the procedure purges all cached versions of the page.

Syntax

APEX_PAGE.PURGE_CACHE (
    p_application_id       IN NUMBER DEFAULT apex.g_flow_id,
    p_page_id              IN NUMBER DEFAULT apex.g_flow_step_id,
    p_user_name            IN VARCHAR2 DEFAULT NULL,
    p_current_session_only IN BOOLEAN  DEFAULT FALSE );

Parameters

Table 39-3 PURGE_CACHE Parameters

Parameter Description
p_application_id ID of the application. Defaults to the current application.
p_page_id ID of the page. Defaults to the current page. If you pass NULL, Oracle APEX purges the cache on all pages of the application.
p_user_name Specify a user name if you only want to purge entries that were saved for the given user.
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 cache on the current page.

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