On 8-8-2014 21:16, dixonepperson@... [firebird-support] wrote:

> You are missing the SUSPEND; which is necessary when returning data.
> Also you shouldn't have a statement after the DO key word. Rewrite it
> like this:

SUSPEND is not necessary for returning data, suspend is only necessary
for selectable stored procedures (that is: stored procedures that return
multiple rows of data). Given that it is executed as a selectable stored
procedure, it is necessary to have a SUSPEND.

But if the stored procedure only ever modifies one item and returns a
single row (which seems reasonable), then it doesn't need a SUSPEND, but
it needs to be executed using EXECUTE PROCEDURE instead.

Mark
--
Mark Rotteveel