Problem calling Oracle procedure from BizTalk

From: KevinS <SearleK_at_googlemail.com>
Date: Fri, 7 Aug 2009 08:20:42 -0700 (PDT)
Message-ID: <dbd8d54e-8bed-4bc7-8477-f6de7e20b240_at_l35g2000vba.googlegroups.com>



Hello,

I hope this is the right group for this.

We are trying to extract data from an Oracle 10.2.0.1.0 database using BizTalk 2009.

We have created a procedure that returns the data though a parameter of type ref cursor which we plan to call through a recieve port.

In the development environment this works, or at least we can get the meta data, but at run time this errors with a system not supported error, despite the fact that Microsoft claim it should work.

I appreciate this is not purely an Oracle issue but has anyone come across this before?

Thanks. Received on Fri Aug 07 2009 - 10:20:42 CDT

Original text of this message