Subject RE: [firebird-support] Select from sp (FB 1.52)
Author Alan McDonald
> 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
> 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.