Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Clearing APEX Region Cache for just a single user

652009Sep 17 2009 — edited Sep 17 2009
I have a long running query which populates a region. Each user can enter their own selection criteria (i.e. search by name, ssn or address, etc..). So I set this region up to "Cache By User" with a timeout after 10seconds.

My problem is how do I clear the cache for just A user. When I look in the APEX_APPLICATION_CACHING view, I can see the entries for each user.
Using APEX_UTIL.PURGE_REGIONS_BY_APP() seems to delete everyone from application cache.

So my quesiton is, is there a PURGE_REGIONS_BY_USER api some where ? Or something that lets me purge the region cache for just one user ?

Thanks!
This post has been answered by 60437 on Sep 17 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2009
Added on Sep 17 2009
2 comments
697 views