Re: Can Oracle do nested transactions?

In <6lm7tr$eiv$1_at_cleavage.canuck.com> Heidi K. Barg (heidi_at_stepforward.org) wrote:

> 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.

There no support 'nested' transactions. But You can use savepoints. According to You example:

begin transaction
  savepoint sp1
    insert into table1...
  savepoint sp2
    select ... from table1 ...
rollback to savepoint sp1

This can't be named 'nested transaction' but i hope it can help You.

--
Is There Is A God Or Any Kind Of Justice Under The Sky... (Queen'91)

Igor V. Podolsky (igoryok_at_soft-review.kiev.ua)