problem with error handling method

• winston Smith

  SSCoach

  Points: 19500

  More actions

  March 24, 2006 at 9:39 am

  #112524

  i have a cursor with an if/else statement inside it. at the end of each if, or else i have a line:

   

  if(@@ERROR <>0)

  GOTO ErrorHandeler

   

  the ErrorHandeler function is outside just before the last End statement of the sproc. the prob is when the cursor finishes, and the program flow comes outside the cursor this method gets called. how do i prevent this??

   

  ErrorHandler:

  BEGIN

  DECLARE @ErrFormatStr varchar(255)

  RAISERROR (@ErrFormatStr, 1, -1, 'copyPermissionsError', 100001,0)

  RETURN -200

  END

  END --last end statement

• allen davidson

  SSCertifiable

  Points: 7042

  More actions

  March 24, 2006 at 9:46 am

  #628671

  You could put a RETURN before your ErrorHandler: Alternately always assign @@ERROR to a local variable - for Example @ReturnValue.

  Then in ErrorHandler you can test @ReturnValue

  .