APEX

Hi,

We have some pages which use Session 0. I also have some application items which have corresponding application computations that get set "On New Instance". The computations are pulling values from a table.

When we first access a page with session 0 the application items are set by the computation and then they maintain that state. We run into an issue when I change the values in the back end and want them propagated to the application items. For clients who have "normal" sessions they can wait until their next login, however session 0 maintains the "old" values. Is their a way to purge or clear session 0 so all the session variables are reset etc?

Here's an example:

App Item: F_EMP_COUNT

App Comp: SQL - On New Instance

select count(*)
from emp


Application Access:

Px w. Session 0 is accessed for the first time:
- F_EMP_COUNT is set with 10 (the number of employees)
...
time passes
...

I now insert a new record in emp and realize that I need to update values in session 0's state

At this point I'd like to purge session 0 so that the next time it is accessed it's values are reset.

Thank you,

Martin

-----
[http://apex-smb.blogspot.com/]