Error handling with a called stored procedure

• kuopaz

  Default port

  Points: 1449

  More actions

  February 25, 2022 at 12:16 pm

  #3988779

  Stored procedure OUTER_TEST calls stored procedure INNER_TEST.

  If an error in INNER_TEST, how do I capture the error message (to store in a table). When I have a try-catch in OUTER_TEST, I can only access a later error message and not the initial one from INNER_TEST?

• Eirikur Eiriksson

  SSC Guru

  Points: 182911

  More actions

  February 25, 2022 at 1:06 pm

  #3988817

  Add a try-catch with error reporting in the inner procedure

  😎

• kaj

  SSCommitted

  Points: 1605

  More actions

  February 25, 2022 at 1:41 pm

  #3988843

  You have to re-throw the error from the catch section of the inner sp, so that it may be caught by the calling outer sp.

  https://docs.microsoft.com/en-us/sql/t-sql/language-elements/throw-transact-sql?view=sql-server-ver15