Re: Problem calling Oracle procedure from BizTalk
From: ddf <oratune_at_msn.com>
Date: Fri, 7 Aug 2009 08:39:01 -0700 (PDT)
Message-ID: <99505331-5220-4026-9836-a651d2902910_at_f10g2000vbf.googlegroups.com>
On Aug 7, 10:20 am, KevinS <Sear..._at_googlemail.com> wrote:
> 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.
Date: Fri, 7 Aug 2009 08:39:01 -0700 (PDT)
Message-ID: <99505331-5220-4026-9836-a651d2902910_at_f10g2000vbf.googlegroups.com>
On Aug 7, 10:20 am, KevinS <Sear..._at_googlemail.com> wrote:
> 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.
Have you performed this step in the BizTalk setup:
http://www.codeproject.com/KB/biztalk/BizTalk_Oracle_adapter.aspx
David Fitzjarrell Received on Fri Aug 07 2009 - 10:39:01 CDT