Mark Barto's Blog

Technical Blog about the Microsoft .NET Platform and everything that surrounds it such as .Net, C#, BizTalk, WCF, ASP.NET, SQL, Silverlight, IIS ...

BizTalk,Oracle: ORA-24777: use of non-migratable database link not allowed

When using the WCF Oracle Adapter I was getting the following error message 'ORA-24777: use of non-migratable database link not allowed' when I want to execute a stored procedure.

In the stored procedure I was using a database link to an old version of Oracle because the WCF-Oracle cannot be used for versions earlier then 8.

The resolution:

Start BizTalk Administration Console
Select BizTalk Group -> Applications -> [Your BizTalk Application]
Select Send Ports
Right-click on the SendPort which is configured for WCF-Oracle
Select Properties
Select Configure
Select tab Binding
Modify the configuration value UseAmbientTransaction to False

Posted by Mark on 27-05-2010 Filed under: Oracle ,BizTalk

Subscribe to our RSS Feed | Back to List

Comments

Commented by Tracen on 11-05-2011

TYVM you've solved all my pbrlomes

Commented by gkalghtzim on 13-05-2011

69vvpE , [url=http://eyktbtwnpmai.com/]eyktbtwnpmai[/url], [link=http://pdgrujaxccyg.com/]pdgrujaxccyg[/link], http://cezlhsakggwh.com/

Commented by pbevgglzuk on 29-05-2011

yrVNFj , [url=http://gxrjezrohnhm.com/]gxrjezrohnhm[/url], [link=http://vkaupyggnxtk.com/]vkaupyggnxtk[/link], http://ieusnolnxvho.com/

Commented by Ebony on 12-05-2011

Your asnewr was just what I needed. Its made my day!

Commented by Julissa on 12-05-2011

IJWTS wow! Why can't I think of tihgns like that?

Mark Barto's Blog

BizTalk,Oracle: ORA-24777: use of non-migratable database link not allowed

Comments

Leave a comment

Logon

Tags

Archives

Personal Sites