> 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?
>
> Thanks,
>
> Nick

I suspect your return parameters are of the wrong type/and or size for the
selected fields to fit inot.
Show your SP complete with the relevant field types of the tables fields
being selectted.
Alan