7 Replies Latest reply: Jan 3, 2013 5:41 AM by BluShadow RSS

    Execute Stored Procedure from another Stored Proc output

    936666
      Hi,
      Is there any example to see how to work on the below condition
      exec Sp1 param1 in, param2 in,param3 in,param4 in, param5 out
      on successful completion of the above

      output param5 of sp1 is input of sp2 param1 with additional parameters
      exec sp2 param1 in, param2 in,param3 out  
      output param3 of sp1 is input of sp3 param1 with additional parameters
      exec sp3 param1 in, param2 in 
      Thanks!