Subject | Select from sp (FB 1.52) |
---|---|
Author | nikicab_1999 |
Post date | 2005-09-18T05:41:17Z |
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 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