Set item value in Session using PL/SQL


Hi ,

Some times i feel that the value of item is not set to session state. we can not save the value to session state untill unless we use submit the page with the item or submitting the page items as well.


let say we have an Item as "P1_DEPT". On that Page Item Use this Event.


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

in plsql Code :

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


Page Items to Submit >P1_DEPT




Post a Comment

0 Comments