Subject Re: [Firebird-Architect] RFC: Please unify stored procedure
Author Dmitry Yemanov
"Ann W. Harrison" <aharrison@...> wrote:
>
> That doesn't work. Try this:
>
> set term ^;
> create procedure xxxx (return x integer)
> as begin
> x = 1;
> end^
>
> You'll find that xxxx has an output parameter, but returns
> no values when executed from a select.

This is the only problem in this discussion, IMO. Should be {CALL} XXXX
described as select or execute? If the former, should it return one row or
an empty set? I'm afraid that Roman wants one row and this will require some
changes in the engine which I'd very much like to avoid.


Dmitry