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:
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
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
