Re: Autonomous Transactions

From: <devjnr_at_gmail.com>
Date: 28 Aug 2006 05:19:30 -0700
Message-ID: <1156767570.707678.36190@b28g2000cwb.googlegroups.com>

I noticed that a commit inside a procedure, commit also all changes outside its begin...end block.

Is it possible? Why?

begin

     insert into test values ('test');
     aaa_proc1; -- in this procedure at the end there is commit

instruction.

end;

This anonymous block cause 'test' value to be inserted.

Is it correct? I think (proc) commit should affect only its begin end bloc....

??? Received on Mon Aug 28 2006 - 07:19:30 CDT