- This topic has 1 reply, 1 voice, and was last updated 9 years, 2 months ago by
.
-
Posts
-
-
I need an example of polling an oracle procedure from Biztalk. Specifically, I’m having heck finding how to configure the receive port once deployed. I’m attempting to call a procedure wrapped in a package with a refcursor.
Steps I’m aware of:
1. Generate Schema using consume adapter in VS2005
2. Create message of the type generated (I used the one with the array, since I’ll attempt to debatch too)
3. Create the most simple map possible to pass the message directly out (I’m going to feed a file folder for now while I learn)
4. Sign and Deploy
5. ???
6 . Success
-
I eventually found a solution to my question.
VS generates 3 schema’s for a package. One is the response, one is the request (“polling statement”) and the other contains the “polling action”
Once you’ve put in your statement and action, the adapter will recieve the data as if you are running the procedure directly, though you cannot just use “exec package.procedure()”
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.