Obtaining a response from an SQL Stored Procedure

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Obtaining a response from an SQL Stored Procedure

Viewing 1 reply thread
  • Author
    Posts
    • March 13, 2006 at 12:16 AM #13132
      community-content

        Hello

        I am calling a stored procedure from within BizTalk.

        Inside the stored procedure I have a variable called isOK whcih is set to 0 at first but if everything executes inside the SP it sets the variable to 1.

        Now I have a decide shape inside my orchestration and I want to say …

        If SP.isOK = 1 then …..

        Else ……..

        But how do I access the isOK variable from within an orchestration?

        Regards
        JMan

      • March 13, 2006 at 5:06 AM #13133
        community-content

          you can access your variable by using select ststement
          SELECT @ISOK AS ISOK FOR XML RAW

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.