Re: How to Handle Forms Error in Triggers??
Date: Tue, 22 Jul 2003 17:33:45 -0700
Message-ID: <3F1DD7E9.D759BACA_at_exxesolutions.com>
Aaron V wrote:
> "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3F149393.BC684CC_at_exxesolutions.com...
> > Aaron V wrote:
> >
> > > I'm trying to handle an error in the Exception area of the code, but the
> it
> > > is a Forms error(FRM)
> > > not a DataBase error (ORA). Something to the effect of this...
> > >
> > > DECLARE
> > > bool_tf BOOLEAN;
> > > NO_LOV_DATA EXCEPTION;
> > > PRAGMA EXCEPTION_INIT(NO_LOV_DATA, -41830);
> > > BEGIN
> > > bool_tf := SHOW_LOV('LOV_DEPENDENTS');
> > > EXCEPTION
> > > WHEN NO_LOV_DATA THEN
> > > MESSAGE('No Data Returned For LOV',ACKNOWLEDGE);
> > > END;
> > >
> > > Is there a way to do something like this locally, without a ON-ERROR
> > > trigger??
> > > In this case I could pre-test the LOV by executing the same Select
> > > Statement,
> > > but in general, is there a way to handle FRM errors In the Same Code
> Block?
> > >
> > > Thanx,
> > >
> > > Aaron V
> >
> > Other than using SHOW_ALERT ... what is wrong with your code?
> >
> > -
>
> The code Does NOT catch the error...grr! I could handle this with ON-ERROR
> trigger. But I want to know how to Handle Forms Errors (FRM-XXXX) in the
> Exception Area
> if it's Possible. Is there a way to Catch Forms Errors like Exception_init
> Works with ORA errors??
>
> Thanks Again,
>
> Aaron V.
>
> -
> > Daniel Morgan
> > http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> > damorgan_at_x.washington.edu
> > (replace 'x' with a 'u' to reply)
> >
> >
Trap the error at the form level in the ON-ERROR trigger trapping for the original message from the database.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Jul 23 2003 - 02:33:45 CEST