Subject | Re: [Firebird-Architect] RFC: Please unify stored procedure |
---|---|
Author | Ivan Prenosil |
Post date | 2004-12-22T13:20:15Z |
From: "Jim Starkey" <jas@...>
0 - unknown
1 - selectable
2 - executable
3 - selectable + executable
Ivan
> A modest proposal: We add a new field RDB$PROCEDURE_TYPE. A type 0Sound reasonable. Shouldn't it be
> procedure is unknown (for backwards compatibility). A type 1 procedure
> is a pseudo-table. A type 3 procedure is one that return discrete
> values rather than a record set. The procedure compiler sets
> RDB$PROCEDURE_TYPE to 1 if it sees a suspect, otherwise it sets it to 2.
0 - unknown
1 - selectable
2 - executable
3 - selectable + executable
Ivan