Subject Re: [firebird-support] Fake error "arithmetic exception, numeric overflow..." on stored procedure or trigger
Author Mark Rotteveel
On 21-2-2018 12:29, marco andreolli drazde@... [firebird-support]
> 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?

AFAIK, this can happen if you changed the definition of a column to be
wider, but did not recompile the triggers or stored procedures. Those
are still using the older, smaller size and then break when confronted
with a value that is wider.

Mark Rotteveel