Subject | Re: [Firebird-Architect] RFC: Please unify stored procedure |
---|---|
Author | Dmitry Yemanov |
Post date | 2004-12-21T18:14:58Z |
"Ann W. Harrison" <aharrison@...> wrote:
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
>This is the only problem in this discussion, IMO. Should be {CALL} XXXX
> 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.
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