Subject | Re: [Firebird-Architect] Re: RFC: Please unify stored procedure execution |
---|---|
Author | Vlad Horsun |
Post date | 2004-12-22T09:23:35Z |
> No, I have slightly different opinion regarding EXECUTE PROCEDUREThis will break existing applications.
> 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.
> 4) SELECT should only work with selectable SP and should not compile ifThis will break existing applications.
> you attempt to use it with executable SP.
Regards,
Vlad