Subject Re: [Firebird-Architect] RFC: Please unify stored procedure execution
Author Ann W. Harrison
At 04:27 AM 12/21/2004, Nando Dessena wrote:

>FWIW you could look for output parameters in the SP declaration and
>use the "select" form if you find any. That's what FlameRobin does.

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.


Regards,


Ann