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!

how to clear items / cache in Apex 4.2

steveFredDec 6 2013 — edited Dec 10 2013

Can someone explain how clearing cache or session state processes are supposed to work in Apex 4.2?

I have an application that allows the user to look up records by last name or by social security number

A look up by SSN is one to one and takes the user to a detail page

A look up by NAME displays a list of names where the user can select a user and display the same detail page

The problem is that the application retains the social security number from one look up to the next. So it keeps displaying the same record

even if you enter or select a different SSN.

I've tried creating session state processes to either clear specific items or clear the cache on a page, but nothing seems to work.

Maybe the problem is that I'm not understanding the options for creating these; it says things like  on load before headers, on load after headers, on submit before calculations, after calculations, etc

The application is read only.  Logically to me, if you are linking from one page to another you need to save the value in the item  but if you are doing a  new search you need to clear it

So I thought that on the detail page I should clear the items, or clear the cache on the page after submitting

But can't get this to work

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2014
Added on Dec 6 2013
4 comments
3,405 views