Subject Re: [firebird-support] Select from sp (FB 1.52)
Author Helen Borrie
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
>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