Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Transaction level commits?
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 Thu Oct 07 1999 - 15:48:08 CDT