Re: ON-ERROR Trigger
From: <jjwigg_at_tassie.net.au>
Date: Tue, 12 May 1998 03:51:30 GMT
Message-ID: <6j8h02$m38$1_at_nnrp1.dejanews.com>
> 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.
"I can resist anything but temptation" - Oscar Wilde Justin Wigg
jjwigg_at_tassie.net.au
Date: Tue, 12 May 1998 03:51:30 GMT
Message-ID: <6j8h02$m38$1_at_nnrp1.dejanews.com>
In article <3556F9A7.A09A8000_at_isoft.intranet.gr>, Mavrelos Antony <mavrelos_at_isoft.intranet.gr> wrote:
>
> 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.
"I can resist anything but temptation" - Oscar Wilde Justin Wigg
jjwigg_at_tassie.net.au
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 12 1998 - 05:51:30 CEST