SQL Reference Guide > SQL Reference Guide > SQL Statements > SET > Session With On_user_error
Was this helpful?
Session With On_user_error
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.
Last modified date: 01/30/2023