- This topic has 1 reply, 1 voice, and was last updated 9 years, 6 months ago by
.
-
Posts
-
-
Hi All!
I am using the Oracle adapter provided by microsoft to access the oracle database in the orchestration. I can query the table alright, but cannot manage to call a stored procedure on that database. When we proceed using the 'Generate Schema' wizard, it doesn't show the stored procedures of that database in the list, so we cant select them. There is not a rights issue for the user of DSN, we've checked that, same is the problem with Oracle packages, they are not shown in the list.
Do anyone out there knows why this is happening? if yes then please help. and also if you can redirect me to any good article or tutorial guiding how to use Oracle adapter for Biztalk, which explains the calling of SPs, that'd be great.
Regards,
Sajid
-
I'll try to publish a tutorial on the subject when I get a chance. I haven't seen any so I began one on a recent project for others in the same state.
Make sure to use packages for your stored procedures to be able to view them using the BizTalk Oracle Adapter. Also, use XmlTransmit and XmlReceive pipelines in your send port to be sure your schema is used correctly in your application.
Let us know if this helps since there are a few related posts with similar questions for this "thinly" documented option.
BizTron
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.