Hi guys,

I have a simple stored procedure to update data, like this :

SET TERM ^ ;

CREATE PROCEDURE REG 

AS

BEGIN

    UPDATE table a set a.field1 = '123';

    exit;

END^

SET TERM ; ^

When I run that procedure on flamerobin with this command:

execute procedure Reg.

It runs ok, but without a commit command, the field1 on table won't get update.

I rarely use store procedure to do update / insert / delete, but is this a normal behavior?

Is there any commands to add so commit is no needed?

Thanks in advance.