Get Error Message From Nested Stored Procedure

• Hua hui

  Grasshopper

  Points: 24

  More actions

  March 7, 2005 at 11:51 pm

  #65462

  Hi, all

  In nested SP, I use raiserror send back the customized error message with different return value (eg: 1, 2, 11, 12, 100 ...). I want to have another main SP which will call this sub-SP, inside I have a loop excute this SP.

  How can the main SP get error message from nested SP so that I can insert those return error message to a table? Is it possible? I know one way is to add additional output parameter (varchar) to store the error message instead of raiserror...

  Thanks,

   

   

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  March 8, 2005 at 2:18 am

  #545827

  In all cases, the actual raiserror will be sent to the calling client.

  Can you expand a bit (some simple example maybe) on what you want to do ?

  /Kenneth