Subject Re: [Firebird-Architect] Re: RFC: Please unify stored procedure execution
Author Martijn Tonies
> > 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.

Is this possible? Will a non-singleton select-able procedure return any
additional rows if used via EXECUTE? No, it won't. How will it be
able to raise an exception?

> > 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.

Why? Using SELECT with a non-selectable SP always returns an empty
resultset. Would anyone actually use that?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions