error handling

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  October 22, 2003 at 7:39 am

  #101727

  in a stored procedure i am executing another procedure ,now i have to trap the error which is generated by called procedure,plz give proper soution for this inner procedure error handling

• guarddata

  SSCertifiable

  Points: 6583

  More actions

  October 22, 2003 at 8:29 am

  #479109

  We RETURN the error code from each procedure. You might trap the errors in something like this

  EXEC @errorcode = OtherStoredProc ...

  SET @procErr = @@ERROR

  IF @procErr <> 0 GOTO InProcError

  IF @errorcode <> 0 GOTO CalledProcError

  Guarddata-