26.8 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

PROCEDURE 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 26-2 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 Application Express 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;

Parent topic: APEX_PAGE