Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Exiting a 10g form without validation
papalphaus_at_yahoo.com wrote:
> On Feb 15, 7:42 pm, DA Morgan <damor..._at_psoug.org> wrote: >> papalph..._at_yahoo.com wrote:
>> When you trap an error, anywhere, and don't re-raise it Oracle assumes >> it has been dealt with. Does your WHEN-VALIDATE-ITEM trigger contain an >> exception handler? >> -- >> Daniel A. Morgan >> University of Washington >> damor..._at_x.washington.edu >> (replace x with u to respond) >> Puget Sound Oracle Users Groupwww.psoug.org > > Yes, it does have an exception which displays a message. That is the > problem, this messages pops up 4 times then the question 'Do you want > to close this form' after the user clicks on the red X to exit the > form.
If the WHEN-VALIDATE-ITEM trigger has an exception handler then the exception has been dealt with there and will not bubble up to the block or form level.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Feb 16 2007 - 10:22:14 CST