Can Oracle do nested transactions?

From: Heidi K. Barg <heidi_at_stepforward.org>
Date: 1998/06/10
Message-ID: <6lm7tr$eiv$1@cleavage.canuck.com>#1/1

If I do the following pseudo on an empty table:

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 have any rows at all.

I'm not sure if I am missing some sort of configuration variable or what I'm doing wrong.

thanks,
 heidi Received on Wed Jun 10 1998 - 00:00:00 CDT