Can Oracle do nested transactions?
From: Heidi K. Barg <heidi_at_stepforward.org>
Date: 1998/06/10
Message-ID: <6lm7tr$eiv$1_at_cleavage.canuck.com>#1/1
rollback transaction
Date: 1998/06/10
Message-ID: <6lm7tr$eiv$1_at_cleavage.canuck.com>#1/1
[Quoted] [Quoted] If I do the following pseudo on an empty table:
[Quoted] begin transaction
begin transaction
insert into table1 (a,b) values (1, empty_clob()) commit transaction
select b from table1 where a = 1 for update OCILobWrite(...)
rollback transaction
then, a row is inserted that contains a=1, and b=empty whereas it should not [Quoted] have any rows at all.
I'm not sure if I am missing some sort of configuration variable or what I'm [Quoted] doing wrong.
thanks,
heidi
Received on Wed Jun 10 1998 - 00:00:00 CEST