Re: Transaction level commits?

From: Doug Cowles <dcowles_at_nospambigfoot.com>
Date: Sat, 09 Oct 1999 01:20:15 -0400
Message-ID: <37FED08E.6523AD1C@nospambigfoot.com>

Maybe..I'm not sure. The essential question is :

TXN A

       Select * for update from x where id =y
              TXN B
                    update x where id =y
                    commit
               END TXNB
          ??? Is row y in table x still locked for update here???????????????

          update x where id =y
         commit

END TXN A Jonathan Lewis wrote:

> You may be thinking of 'autonomous transactions'.
> You can layer transactions within transactions,
> but a lower level transaction has to commit or rollback
> before the upper layer can continue.
>
> If the diagram works:
> TXA
> insert row1 into table X
> TXB
> insert row2 into tableY
> commit;
> rollback; -- which is at TXA level
>
> row 2 will be inserted into tableY
> but row1 will not be inserted into tableX
>
> Done with
> pragma autonomous_transaction
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Doug Cowles wrote in message <37FCD2E4.7F9AC48F_at_nospambigfoot.com>...
> >I heard there is a new facility in Oracle 8 that allows you to hold some
> >locks (transactions) at another level then the all or nothing commit.
> >That there is a higher level of locking that you can use, to commit
> >"some" of the transactions.
> >
> >Is this true?
> >- D
> >

Received on Sat Oct 09 1999 - 00:20:15 CDT