Subject Re: [Firebird-Architect] Re: Procedures vs functions
Author Alex Peshkov
Dmitry Yemanov wrote:
> There was a similar discussion regarding executable vs selectable procedures
> 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>
>

This will break backward compatibility. I know a lot of places, where
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.