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.
