Re: Commit

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 1 Jun 2001 11:33:11 +0100
Message-ID: <991391665.23113.0.nnrp-13.c30bdde2@news.demon.co.uk>

Autonomous transactions. I haven't looked at them much, but a walk round google (or oracle documentation) should help.

Also: http://www.indiana.edu/~dbateam/resources/tips/oracle_trans_mgt.html

"Ivica Dimjasevic" <smokesoft_at_email.hinet.hr> wrote in message news:9f7ku0$2kcb$1_at_as201.hinet.hr...
> Let I have two procedures:
>
> create procedure proc1 is
> begin
> ...
> proc2;
> ...
> end;
>
> create procedure proc2 is
> begin
> ...
> commit;
> end;
>
> How to get proc2 to commit only changes made within proc2 and not to
commit
> changes within proc1.
>
>
> Thanks,
> Ivica
>
Received on Fri Jun 01 2001 - 05:33:11 CDT