What form trigger will get executed right before the form closes?
658749Oct 22 2009 — edited Oct 22 2009I am trying to place a common routine in our existing oracle forms which I want to get executed right before the form closes or even perhaps after the form exits if any. This routine will execute a java function and I want it to be the last routine to execute after EXIT_FORM is invoked, that means after all validation, alert or messages or whatever oracle forms is doing before closing the form.
I tried POST-FORM, but it seems this will only get executed during normal exits as per documentation and won't get executed during upnormal exit. (As per oracle doc - 'This trigger does not fire when the form is exited abnormally, for example, if validation fails in the form. ').
I can't place it before the EXIT_FORM statement on the KEY-EXIT as well because in that case the java function will get executed and I don't know if the form terminates successfully or not.
Any thoughts would be very helpful.
Regards,
Lester