Set item value in Session using PL/SQL

Some times I feel that the value of item is not setting to it’s session state. we can not save the value to session state until unless we use submit the page with the item or submitting the page items as well.

Now try to set it without loading the page, let say we have an Item as “P1_DEPT”.

Create a Dynamic Action for the Item .

Create Dynamic Action> Event > change Selection Type > Items>P1_DEPT

Action > Execute PL/SQL code >

APEX_UTIL.SET_SESSION_STATE ('P1_DEPT',v('P1_DEPT'));


Page Items to Submit > P1_DEPT Now type into item 

See the Session State