| Subject | RE: [Firebird-Architect] Re: RFC: Please unify stored procedure execution |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2004-12-22T07:57:49Z |
"Samofatov, Nickolay" <nickolay@...> wrote:
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
value)
???
Dmitry
>Let me see whether I got this thing right.
> 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.
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
value)
???
Dmitry