Adapter Pack WCF : Transaction with Oracle

After reinstalling the oracle client on a BizTalk Server, I faced to an issue about transaction with a receive location WCF Custom:
 
The adapter "WCF-Custom" raised an error message.
Details "Microsoft.ServiceModel.Channels.Common.ConnectionException:
Unable to load OraMTS ---> Oracle.DataAccess.Client.OracleException Unable to load OraMTS

Indeed the System.Transaction in .Net Environment is converted to an Oracle transaction by the adapter and the OraMTS object (from the Oracle client) wasn’t found. This conversion is due to the following reason :

The Oracle Database adapter does not support performing transactions

on the Oracle database using System.Transaction.

The adapter supports transactions using OracleTransaction.

as we can see on msdn page

So the issue is to verify that you have correctly installed the component : Oracle Services for Microsoft Transaction Server to get the OraMTS Object.

Source :

http://seroter.wordpress.com/2008/05/16/flowing-transactions-to-oracle-using-adapter-pack/

This entry was posted in BizTalk. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s