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;