Subject Re: [IBO] SP error??
Author Burak OZLER
No solution for a whole day... I'm trying to find the bug no solution. I
remove all the Turkish characters from the SP's variables but I'm still
having the error;
"arithmetic exception, numeric overflow, or string truncation"
I can send you the SP's no problem for me..

I belive this problem is IBO related I try this SP's from IBExpert with 0
errors;


----- Original Message -----
From: "Helen Borrie (TeamIBO)" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, January 15, 2002 4:33 PM
Subject: Re: [IBO] SP error??


> 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
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>