The SET SESSION WITH ON_USER_ERROR option enables you to specify how user errors are handled in the current session. To direct the DBMS to roll back the effects of the entire transaction if a user error occurs, specify ROLLBACK TRANSACTION. To revert back to default behavior, specify NOROLLBACK.