On 8-8-2014 21:16, [email protected] [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
