RE: set transaction bug?

From: Jack Silvey <JSilvey_at_XOL.com>
Date: Fri, 30 Jun 2000 15:49:52 -0500
Message-Id: <10544.111018@fatcity.com>

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
senior @ xol.com

-----Original Message-----
From: Shaw, John B [mailto:jbshaw_at_ingr.com] Sent: Friday, June 30, 2000 4:06 PM
To: Multiple recipients of list ORACLE-L Subject: set transaction bug?

Is there a bug in 8.0.5.0.0 with set transaction? I did :

set transaction use rollback segment bigroll; and it didn't use it.
It was the first statement after starting sqlplus. Received on Fri Jun 30 2000 - 15:49:52 CDT