Question Regarding Nested Procs!

• chinn

  SSCrazy

  Points: 2840

  More actions

  April 23, 2007 at 2:36 pm

  #119834

  Hello Everybody,

  Hopefully I am clear here if not pls let me know.

  I have a proc where i am calling a another proc inside main now my question is

  Let's name Main Proc and Inner PRoc

  Now when it comes to the step in Main Proc where it executes inner proc does it wait untill the Inner Proc is successfull or it just executes and goes to the next step in the Main proc.

  Next Question..how to handle the errors in the inner proc especially while calling inside a proc.

  if i do this

  IF @@ERROR <> 0

     BEGIN

        -- Rollback the transaction

                             ROLLBACK

        -- Raise an error and return

      RAISERROR ('Error in Inner Proc', 16, 1)

      RETURN

     END

    

  in the inner proc on error does it come back to the main proc or what happens..

  Your Help is greatly appreciated.

  thanks in advance

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  April 23, 2007 at 3:36 pm

  #702037

  You need to read EXECUTE topic in BOL.

  @return_status is what you gonna be interested in the most.

  _____________
  Code for TallyGenerator