APEX-AT-WORK no image

Clear the page cache with PL/SQL

Von Tobias Arnhold 2.24.2011
I just stumbled into a problem where I needed to clear the page cache inside an APEX PL/SQL process.

It is quite easy if you know how:

APEX_UTIL.CLEAR_PAGE_CACHE (160);

-- APEX_UTIL.CLEAR_PAGE_CACHE (
-- p_page IN NUMBER DEFAULT NULL);
-- Description: This procedure removes session state for a given page for the current session.


There are two other similar functions:
CLEAR_APP_CACHE, CLEAR_USER_CACHE

For more information watch the documentation for APEX_UTIL:
http://download.oracle.com/docs/cd/E10513_01/doc/apirefs.310/e12855/apex_util.htm#BABCIAFJ

Post Tags:

No Comment to " Clear the page cache with PL/SQL "