Subject | Re: [Firebird-Architect] RFC: Please unify stored procedure execution |
---|---|
Author | Ann W. Harrison |
Post date | 2004-12-21T18:06:42Z |
At 04:27 AM 12/21/2004, Nando Dessena wrote:
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
>FWIW you could look for output parameters in the SP declaration andThat doesn't work. Try this:
>use the "select" form if you find any. That's what FlameRobin does.
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