Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Calling a stored procedure in an orchestration
- This topic has 3 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
May 19, 2009 at 1:27 PM #22410
I am a newbie to Biztalk. My life has been pretty much with midrange systems like the AS/400. I have a need to call a stored procedure in the AS/400 from Biztalk. This stored procedure populates a file in the AS/400 which then is used by Biztalk to create ASN information to be sent to our customers. My question is, how and where do I define and invoke this stored procedure from Biztalk.
-
May 20, 2009 at 12:10 AM #22420
You can create a C#/VB class library project, write a helper class with method to call the store procedure. Build the project/DLL with strongname, add DLL as reference to your BizTalk project. Call your help class/method to call the stored procedure. Hope this helps.
-
May 20, 2009 at 5:14 AM #22426
Thanks for your reply. I was able to generate a schema with the auto generation to call the CL program, but now I am having errors with my orchestration. I get two errors. The first error states “use of unconstructed message”. The second error states “an activatable receive must be the first executable statement in a service. I created the messages in the orchestration with the multi-part message type. I do not understand. I need to call the CL program first then do my receive of the data.
-
May 20, 2009 at 10:42 PM #22438
Error #1: use of unconstructed message
This indicates you are using a message that has not been constructed. This is usually cause by one of the followigs:
- message is not constructed before it’s used, i.e. not constructed inisde a “Construct Message” shape, or it’s not constructed inside a construct statement. You can use one of the methods described here: http://blogs.objectsharp.com/cs/blogs/matt/archive/2004/11/09/1009.aspx
- “an activatable receive must be the first executable statement in a service”: the first shape has to be a receive shape with “Activation” property equal to true if the orchestration is to be started by an arrival of a certain message
-
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.