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 page items values from memory?

smoliveiraFeb 4 2016 — edited Feb 12 2016

Hi all,

I created an HTML region with several page items (select lists, date pickers and popup lovs) on Apex 4.2. This region works as a search form. The region has also two buttons: Search and Clear.

When the user clicks on "Search" button, the page is submitted and my report is showed based on the page items values (select lists, date pickers and popup lovs).

Then, if the user clicks on "Clear" button, all the page items values should be reset to NULL. In order to accomplish this, I created a "After Submit" process with type "Clear Cache for all Items on Pages (PageID,PageID,PageID)" and with the condition when "Clear" button is pressed.

All my items on "Mantain session state" have "Per user" selected. If the user logouts from the application and then returns later, he/she can see the values entered/selected previously.

Although, when I check the session state (click on "Session" link at the bottom of the page), I can see all the items with status "RESET_TO_NULL", on the screen I continue to see the values on each item. This just happened after I changed from "Per session" to "Per user" on "Mantain session state".

I read this article:

Anton Nielsen: Oracle Application Express (APEX): Three Kinds of Session State : Oracle, 10g, 10gAS, Application Express…

And it seems to me my page items are on "IN MEMORY Session State (IMSS)". Am I right? How can I clear them from this type of memory?

Thank you in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2016
Added on Feb 4 2016
9 comments
5,066 views