Home Page › Forums › BizTalk 2004 – BizTalk 2010 › ORA-02074: cannot ROLLBACK in a distributed transaction › Re: ORA-02074: cannot ROLLBACK in a distributed transaction
September 15, 2008 at 12:10 PM
#20721
Have you verified that the issue is specifically with the WCF Oracle adapter calling the SP? For example, can you call the SP successfully outside of BizTalk? A good test would be to write a small C# app to call the SP, and run it from the BizTalk server. Can you access Oracle at all using the WCF adapter? For example, try calling another SP or just selecting some data from a table.