Subject Re: [Firebird-Architect] RFC: Please unify stored procedure
Author Dmitry Yemanov
"Ann W. Harrison" <aharrison@...> wrote:
> My suggestion is that we add the RDB$PROCEDURE_TYPE
> field, filled in when the procedure is compiled and
> do nothing else. No additional checks, errors, or
> anything.
> 1) Existing stuff, including really warped procedures
> that do one thing when invoked with EXECUTE PROCEDURE
> and another when SELECTED still work - as well as they
> ever did.
> 2) Interface layers no longer have to parse procedures
> to guess the best way to invoke them.
> 3) Naive users get a hint of how the system thinks their
> procedure should be invoked.

Nice summary, Ann :-) I second this suggestion.