At 04:17 PM 15-01-02 +0200, Burak wrote:

>Hi all;
>
> My sp runs very well and do the things it have to do. But it returns
>this error.
>ISC ERROR CODE:335544321'
>'ISC ERROR MESSAGE:
>arithmetic exception, numeric overflow, or string truncation
>
>my connections charset win1254(true)
>
>why I'm having this error???

If the input character set is also Win1254 then it's not a problem with 2-byte character input causing the overflow.

It could be a string input that is too long for the field you have defined (are you checking inputs to be sure? are you concatenating strings in your procedure and forming new strings which are too long?)

Are you trying to push an Int64 value into an integer?

Are you performing a multiplication or division on a scaled numeric that is increasing the precision beyond that defined for the field?

Is your procedure potentially performing a division by zero?

etc.
etc.

The answer will be somewhere in the data...


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at www.ibobjects.com