Subject | Re: [Firebird-Architect] RFC: Please unify stored procedure |
---|---|
Author | Jim Starkey |
Post date | 2004-12-21T20:46:50Z |
A modest proposal: We add a new field RDB$PROCEDURE_TYPE. A type 0
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.
If someone wants to get cute and put a suspend where it doesn't belong,
he will get something unpredictable, which is only justice.
--
Jim Starkey
Netfrastructure, Inc.
978 526-1376
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.
If someone wants to get cute and put a suspend where it doesn't belong,
he will get something unpredictable, which is only justice.
--
Jim Starkey
Netfrastructure, Inc.
978 526-1376