This content has been marked as final. Show 4 replies
A simple solution is to remove the success message from the DML process (which as you know doesn't display the success message unless an actual DML update is made). Then create a new PL/SQL process with just "NULL;" as the source and add the success message there.
Thanks for the reply. I tried something along these lines, but I cannot seem to be able to access #MRI_COUNT# and #MRU_COUNT# except in the DML update process.
Ok, put your success message back in the main DML process (I didn't know it was a tabular form process). Then make the success message for your NULL process something generic and static. Make sure your NULL process is after the main DML process and make it conditional. Use the PL/SQL Expression condition type and enter the following for the condition:
Let me know if that does it for you.
wwv_flow.g_print_success_message IS NULL
Thanks, again, Dan.
The new conditional process has done the trick. I can now put in a 'No changes to apply' message and the pop-up always closes neatly.
ps if I knew how to put reward points on for you, I would, but I'm sure you don't need them ;)
Edited by: user3282753 on 04-Mar-2013 09:06