Subject Re: [Firebird-Architect] Re: RFC: Please unify stored procedure execution
Author Vlad Horsun
> No, I have slightly different opinion regarding EXECUTE PROCEDURE
> handling in PSQL code.
>
> 3) EXECUTE PROCEDURE remains singleton construct and works either with
> executable SP or singleton selectable SP.
> If selectable SP does not return rows or returns more than one row we
> need to handle it according to standard logic, basically raise exception
> in both cases.

This will break existing applications.

> 4) SELECT should only work with selectable SP and should not compile if
> you attempt to use it with executable SP.

This will break existing applications.

Regards,
Vlad