Re: 'MSDAORA' was unable to begin a distributed transaction - why?! (SQL <-> Oracle)

>I'm performing read-only operations in Oracle only, so as far as I'm concerned, I need no transactions at all

Oracle's concerns are perhaps more relevant :-) Oracle needs to know when your transaction begins so as to know what read-consistent view of the data to give you.

"A transaction in Oracle begins when the first executable SQL statement is encountered. An executable SQL statement is a SQL statement that generates calls to an instance, including DML and DDL statements."

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14220/transact.htm#sthref624

I'm not quite sure I follow why deleting would be a read-only operation. I don't understand non-Oracle trigger syntax.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20060512/news_1b12google.html