|Subject||Re: Re: [Firebird-Architect] RFC: Please unify stored|
> At 06:33 AM 12/21/2004, Vlad Horsun wrote:This is develore's mistake - write procedure without SUSPEND
> > If SP has outputs - do SELECT else do EXECUTE. What is wrong with it ?
> A procedure can have output parameters and produce output
> without having a SUSPEND. Such a procedure returns results
> when called with EXECUTE and returns NO ROWS when called
> with SELECT.
and call it with SELECT. This "problem" is like a "problem" with
FOR SELECT INTO when variable not change it's value if resultset