Yes, I needed it, thanks for your answer.
Regards,
Anto
On 28 Apr 2014 22:23:43 -0700, wrote:
> 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 ; ^
There is no need for a EXIT statement in this stored pr
At 05:23 p.m. 29/04/2014, trsk...@yahoo.com wrote:
>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
>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, b
Hi,
Thanks for your replied.
Tried to use execute STATEMENT 'COMMIT', raised and error
Explicit transaction control is not allowed
> 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
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