From: "Samofatov, Nickolay" <nickolay@...>

> 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 would change current behaviour. See:

Create Procedure P Returns (X INTEGER) As
Begin
X = 123;
SUSPEND;
DELETE FROM TAB;
End

Currently only code up to SUSPEND is executed when called by Execute Procedure.
To test whether there are more than one row the code after SUSPEND would
have to be executed too.

Ivan