Calling a stored procedure in an orchestration

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Calling a stored procedure in an orchestration

Viewing 1 reply thread
  • Author
    Posts
    • #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.

    • #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.

      • #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.

         

         

        • #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:

          1. 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
          2. “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
Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.