Can anyone share a SQL Stored Proc return code example?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Can anyone share a SQL Stored Proc return code example?

Viewing 0 reply threads
  • Author
    Posts
    • #17578

      Hi all,

      I have a stored procedure (called from an orchestration) that performs a lookup in a SQL Server 2005 table, returns a value and it works fine.  The part I am having trouble with is how to trap the lookup when 0 rows are returned, e.g. it can't find a value in the table.  Simple error checking, right?

      I can add a variable in the Stored Procedure but I can't figure out how to access or read the variable in BizTalk.  Anyone have an example?

      Thanks. 

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.