Subject Re: [Firebird-Architect] Re: RFC: Please unify stored procedure execution
Author Dmitry Kuzmenko
Hello, Roman!

Tuesday, December 21, 2004, 2:16:35 PM, you wrote:

RR> Perfect. Then we have a bug. If EXECUTE PROCEDURE is used for stored
RR> procedures that return more then one row using SUSPEND statement, only
RR> first row is returned. Should I fill the bug report?

This is not a bug. SUSPEND is special keyword that allows to fetch
data from procedure using SELECT statement, not EXECUTE PROCEDURE
statement. And, yes, if this does not violate standard and common
behavior, you can RFC to allow execute procedure to return more than
"1 row", if it can.

--
Dmitri Kouzmenko, www.ibase.ru, (095) 953-13-34