Re: Q: Transactions

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/01/30
Message-ID: <32F0C69B.4A72@qrcsun.qrc.org>#1/1

Jim Poland wrote:
>
> What happens if you issue a read/write Set Transaction, then later issue
> another read/write Set Transaction, and then issue two Commits? Does
> some sort of nesting occur or are some of the statements ignored?

SET TRANSACTION xxx must be the first statement of the transaction. As a result, you cannot issue a SET TRANSACTION xxx unless you issue a COMMIT or ROLLBACK just before. It implies you cannot nest it.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Thu Jan 30 1997 - 00:00:00 CST