firebird-support - Re: [firebird-support] Fake error "arithmetic exception, numeric overflow..." on stored procedure or trigger

Subject	Re: [firebird-support] Fake error "arithmetic exception, numeric overflow..." on stored procedure or trigger
Author	Anto Edin Charley
Post date	2018-02-22T02:26:50Z

Check the size of trigger. Sometimes it show like this if the size reaches 64k.

On Feb 21, 2018 21:11, "marco andreolli drazde@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:

Hi,
Recently I have found the error arithmetic exception, numeric overflow, or string truncation
string right truncation
At trigger 'XXXXX'
on different trigger or stored procedure.
The strange thing is that are not true, in the trigger or procedure there isn't any operation that coud produce this exception!

I "recompile" the trigger or procedure that are affected and the error disappear!.
It could be a bug in my relase of Firebird?

Firebird Ver: WI-V6.3.7.27050 Firebird 2.5