This content has been marked as final. Show 4 replies
this is because of 4.2 changes to session state management. It's a performance improvement and reduces redo.
Hi Vikas,1 person found this helpful
as addition to Christians reply, the DML Fetch process has never written anything into permanent session state. So you should have never seen the most current values in the session state popup. You would have seen the values from your last submit.
My Blog: http://www.inside-oracle-apex.com
APEX Plug-Ins: http://apex.oracle.com/plugins
Edited by: Patrick Wolf on Nov 29, 2012 11:35 AM
Christian, Patrick - Honestly, I don't remember the prior behaviour in this regard. I was just surprised that on a wizard generated form-on-table page with dozens of page items, clicking on the session state popup showed only the hidden PK item. Just a little disconcerting. I would have preferred the popup to list all the page items with some footnote to explain why the session state values are not shown. Just my 2c.
I’ve discussed a similar issue with Joel the other day, and I’ve learned that with 4.2, the change Christian mentioned includes displaying only Session State values that were set explicitly by the APEX engine (including, BTW, null values). As Patrick mentioned, if your item/column is defined as “Always”, it doesn’t set permanent (I call it persistence) Session State value, and as such it will not appear in the Page Items Session State popup windows until you submit the page for the first time (and as Patrick stated, this behavior has not changed).
This behavior also span to the Application Item and the (entire application) Session State popup options.
I don’t remember reading about this change of behavior in the documentation, and maybe this should be fixed.
>> Is there a way to get the original behavior back?
As far as I can tell, no. All Session State popup options only display items with explicitly set values. I agree with you that it can be baffling at times. For example, if all your page items are of type “always”, after loading the page for the first time, the Page Item Session State popup window will report “Page has no items.”, which is clearly not accurate. It should report something like Page has no items in session state.
♦ Please remember to mark appropriate posts as correct/helpful. For the long run, it will benefit us all.
♦ Author of Oracle Application Express 3.2 – The Essentials and More