At 05:41 AM 18/09/2005 +0000, you wrote:

>Could someone help me with this issue:
>
>I have a stored proc that returns multiple rows (FOR SELECT
>...INTO..DO SUSPEND) and accepts 2 parameters. When calling it from
>ADO or IB_SQL with SELECT * FROM mysp(0,2) I am getting
>ISC ERROR MESSAGE:
>arithmetic exception, numeric overflow, or string truncation
>
>but if I just extract SELECT part of it and run it through ADO or
>IB_SQL, ite returns records.
>
>What is wrong?

Is your SP prone to a divide-by-zero error when you pass zero in the first
argument?

./hb