Subject | Re: [Firebird-Architect] Re: Procedures vs functions |
---|---|
Author | Alex Peshkov |
Post date | 2006-03-20T10:09:07Z |
Dmitry Yemanov wrote:
selectable procedures (when singleton mode is needed) used as
executable. It was clearly specified in ib6 documentation, that
selectable procedures run in such a case till first select, and finish
working at this point. I always add 'SUSPEND' to the end of any
executable procedure to be able to invoke it as selectable if I need it
later.
> There was a similar discussion regarding executable vs selectable proceduresThis will break backward compatibility. I know a lot of places, where
> and the decision was that they should be clearly separated objects with
> different invocation patterns, so we should have:
>
> 1) Executable procedures, invoked via EXECUTE <procedure name>
> 2) Selectable procedures, invoked via SELECT FROM <procedure name>
>
selectable procedures (when singleton mode is needed) used as
executable. It was clearly specified in ib6 documentation, that
selectable procedures run in such a case till first select, and finish
working at this point. I always add 'SUSPEND' to the end of any
executable procedure to be able to invoke it as selectable if I need it
later.