Subject Re: [IBO] SP error??
Author Helen Borrie (TeamIBO)
At 11:22 AM 16-01-02 +0200, you wrote:
>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..

Yes, send them, and a DDL script of the tables and triggers involved. No large attachments please.

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

That's unlikely - IBExpert uses IBO. The error messages you are getting are from the database, not from IBO. I don't think you have any character-set problem here. My guess is that you are doing something in your application code that is increasing the precision of a number, causing the procedure to receive a parameter with a numeric overflow.

Are you using the SQL Monitor to watch what is being passed?

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