Re: [firebird-support] Stored Procedure

[Ivan Přenosil]

> I have below S.Proc
> Eventhough the table has more than 1 record
> below  S.procedure updates only 1 record.

Because the procedure contains SUSPEND it must be called
using SELECT, not using EXECUTE PROCEDURE.
Ivan