Re: How to Handle Forms Error in Triggers??

[Quoted] "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?
>
> -

[Quoted] 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)
>
>
Received on Wed Jul 23 2003 - 00:46:29 CEST