Re: Can Oracle do nested transactions?

Heidi K. Barg 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.
>
> thanks,
> heidi

It looks like the function empty_clob() is returning null. You cannot rollback after a commit.

Joep Received on Wed Jun 10 1998 - 00:00:00 CDT