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:
> I have a form that is trying to do validation checks when I click on
> the red X to exit the form. I have created a key_exit trigger at both
> the form level and block level with message statements in them so I
> will know when they are firing. None of my messages pop up, but one of
> my item validation failure messages (inside a when-validate-item
> trigger) pops up 4 times then the form asks me if I wish to close the
> form. This is a 10g form running on a 9i instance (soon to be upgraded
> to 10g). Is there not a way that I can just force the form to exit
> whenever the user clicks on the red X?
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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Feb 15 2007 - 18:42:46 CST