• Why are you doing a COMMIT in your CATCH block instead of a ROLLBACK which would be more logical.