|Subject||Store Procedure for updating data, why it is need to commit?|
I have a simple stored procedure to update data, like this :
SET TERM ^ ;
CREATE PROCEDURE REG
UPDATE table a set a.field1 = '123';
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.