Subject | Re: RFC: Please unify stored procedure execution |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-12-21T12:20:27Z |
> This is not a bug. SUSPEND is special keyword that allows to fetchBut that's the only way to create a procedure that returns a result
> data from procedure using SELECT statement, not EXECUTE PROCEDURE
> statement.
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 commonSo, what do you (all) think about extending EXECUTE PROCEDURE?
> behavior, you can RFC to allow execute procedure to return more than
> "1 row", if it can.
Roman