|Subject||RE: [firebird-support] Select from sp (FB 1.52)|
> Could someone help me with this issue:I suspect your return parameters are of the wrong type/and or size for the
> 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?
selected fields to fit inot.
Show your SP complete with the relevant field types of the tables fields