Re: ORA-02074: cannot ROLLBACK in a distributed transaction

Home Page Forums BizTalk 2004 – BizTalk 2010 ORA-02074: cannot ROLLBACK in a distributed transaction Re: ORA-02074: cannot ROLLBACK in a distributed transaction

#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.