RE: set transaction bug?

To my understanding, when you logon to SQLPlus, a set transaction is issued implicitly. Therefore if you do abnormal shutdown of your computer, i.e., quit SQLPlus without issuing any DDL or File -> Exit etc., your transactions are not committed to the tables.

As Jack has said:

                ......... Of course you should get an error if you issue "set trans"

                while in the middle of another trans, .... seems logical.

HTH! Aleem

		-----Original Message-----
		From:	Jack Silvey [mailto:JSilvey_at_XOL.com]
		Sent:	01 July, 2000 2:56 AM
		To:	Multiple recipients of list ORACLE-L
		Subject:	RE: set transaction bug?

		John,

		I have had that happen to me before. It seems like the
screwy answer was to
		issue a commit before the transaction starts so that Oracle
knows that a new
		trans has begun. Of course you should get an error if you
issue "set trans"
		while in the middle of another trans, but hey.

		Jack

		ocp x 2