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

preview preview

Action > Execute PL/SQL code >


Page Items to Submit > P1_DEPT Now type into item preview preview

See the Session State


comments powered by Disqus