Re: ON-ERROR Trigger
From: Mavrelos Antony <mavrelos_at_isoft.intranet.gr>
Date: Tue, 12 May 1998 13:52:07 +0300
Message-ID: <355829D7.B1032F87_at_isoft.intranet.gr>
Date: Tue, 12 May 1998 13:52:07 +0300
Message-ID: <355829D7.B1032F87_at_isoft.intranet.gr>
> > FORMS 5.0
> > ORACLE 7.3.2.3.0
> > When i use ON-ERROR trigger most of the times ORA-06502 message appears.
> > Even with programms made with Forms 4.5 the same message keeps showing
> > on the screen again & again.
>
> 06502 is a numeric/value error. What code is in the trigger? Check you are
> not trying to put a NULL value in a NOT NULL item/column etc.
It has nothing to do with nulls. The only thing i do is to show the error on
alert box.
[Quoted] change_alert_message('alert','message');
dummy :=show_alert('alert');
raise form_trigger_failure;
I tried without the last line(RAISE ...) but i think that the code MUST stop [Quoted] there. After all it's an error trap procedure; Received on Tue May 12 1998 - 12:52:07 CEST