Subject Re: RFC: Please unify stored procedure execution
Author Roman Rokytskyy
> This is not a bug. SUSPEND is special keyword that allows to fetch
> data from procedure using SELECT statement, not EXECUTE PROCEDURE
> statement.

But that's the only way to create a procedure that returns a result
set. But if you define EXECUTE PROCEDURE to be the only statement to
execute procedure (regardless of its type), then we have a bug when it
is used for selectable procedures :)

> And, yes, if this does not violate standard and common
> behavior, you can RFC to allow execute procedure to return more than
> "1 row", if it can.

So, what do you (all) think about extending EXECUTE PROCEDURE?

Roman