How to reset Glogal variable APEX_APPLICATION.G_F0..
878340Jul 27 2011 — edited Jul 28 2011Hi All,
APEX 3.2.
I have the page with list of customers. By clicking on the customer opens Tabular Form with list of some criteria and several check boxes for each criteria. To refer to these check boxes i'm using global variables APEX_APPLICATION.G_F01(i) ... APEX_APPLICATION.G_F05(i). and by Submit button i'm updating the DB table and returning to the list of customers.
Everything works pefect but only ONCE :-) If i need to update criteria for the next customer the arrays of global variables APEX_APPLICATION.G_F0.. are not reseted (cleared) and by Submit containing values for the first customer AND for next one. Honestly it is not what i need.
Clear Cache during After Processing Go_to_Page does not help, or maybe i'm using wrong options.
Could you please give me advice how to clean up these Global arrays APEX_APPLICATION.G_F0.. by Submit or by leaving the page?
Thanks in advance,
Anna