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: <papalphaus_at_yahoo.com>
Date: 16 Feb 2007 05:19:24 -0800
Message-ID: <1171631964.351533.80700@l53g2000cwa.googlegroups.com>


On Feb 15, 7:42 pm, DA Morgan <damor..._at_psoug.org> wrote:
> papalph..._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
> 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. Received on Fri Feb 16 2007 - 07:19:24 CST

Original text of this message

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