Hi,
I am in APEX 5 developed one page with two regions.Objective is show cell number on main region and allow to update the same cell number from another region on same page.
Region 1: Added one Display only Item P2_CELL_NUMBER_SHOW having source from sql return single value. Like "Select cell_number from user_cell"
Region 2 (Hiding this region on page load): Added one text item P2_CELL_NUMBER_UPDATED. On this region added one button "Apply Changes". On Click added dynamic actions in following sequence:
a) PLSQL: Null; Submit item: P2_CELL_NUMBER_UPDATED
b) PLSQL: Calling UPDATE sql Statement to update the cell number in database table.
c) Hiding Region 2 and Showing Region 1 via java script.
d) Refresh Region 1 ( Here I am expecting that item P2_CELL_NUMBER_SHOW should show the new value updated on step b). But getting old value which was earlier on region 1. But when submit page then region 1 get new value.
So, does it require to either submit the page or set session state to get new value on region 1? Will refresh not help in that situation?
Thanks
Ankit