I have a dynamic report that allows users to select checkboxes and processes accordingly.
On submit
FOR i in 1..APEX_APPLICATION.G_F01.COUNT LOOP
#OWNER#.PROCESS_DB_EMAILCHANGE(
P_NEWPASSWD => :P4_NEWPASSWD,
P_DBNAME => APEX_APPLICATION.G_F02(i),
P_LOGGEDINUSER => :APP_USER,
P_PORT => APEX_APPLICATION.G_F04(i),
P_DBUNIQ => APEX_APPLICATION.G_F05(i),
P_HOSTNAME => APEX_APPLICATION.G_F03(i),
P_DOMAIN => :P9999_DOMAIN);
END LOOP;
That works fine and a popup of success goes to the user. And post functions all work fine.
However - if they say submit 3 password resets ........ and then go ahead and do another 3 (different) --- the APEX_APPLICATION.Gxx items are still populated with the OLD values. Why ? How do I reset this ?
I tried a call to APEX_UTIL.CLEAR_PAGE_CACHE(4); at the end --- but that didnt work.
thanks