Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Exiting a 10g form without validation

Re: Exiting a 10g form without validation

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 15 Feb 2007 16:42:46 -0800
Message-ID: <1171586566.150380@bubbleator.drizzle.com>


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.org
Received on Thu Feb 15 2007 - 18:42:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US