BizTalk Server General - calling oracle stored proc from Biztalk 2006

Author

calling oracle stored proc from Biztalk 2006

siddharthkhare@hotmail.com

2006-04-18, 12:46 am

Hi all,
I'm using an oracle adapter to execute a oracle store proc ,i want to
know if the approach is similar to using SQL adapter ?

like in SQL adapter you have to change the sql statement with FOR XML
auto ..etc
to generate the schema on the Biztalk side then you have to change the
stored proc back to return the actual data.

do we have to do soemthing similar when using oracle adapter also.

any details/steps wud be helpful. also how does it change if stored
proc returns OUT var , cursor etc.
appreciate any details.....
-
thanks
siddharth