Subject RE: [Firebird-Architect] Re: RFC: Please unify stored procedure execution
Author Dmitry Yemanov
"Samofatov, Nickolay" <nickolay@...> wrote:
> I agree. It would be nice to have procedure type flag computed by the
> engine based on presence of SUSPEND statement in there.
> If EXECUTE PROCEDURE is called on "selectable" SP it may return
> resultset.

Let me see whether I got this thing right.

1) RDB$PROCEDURE_TYPE is introduced and calculated by the engine
2) Client-side EXEC PROC is described as either select or execute depending
on this value
3) Since we don't have cursor datatypes, PSQL EXEC PROC needs an iteration
extention (e.g. FOR EXEC PROC)
4) FOR EXEC PROC is not allowed for non-suspend procedures
5) PSQL simple EXEC PROC behaves like now (don't care about the new type