Subject Re: [firebird-support] Re: Getting Invalid Request BLR at offset 49 ?
Author Mark Rotteveel
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 Rotteveel