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: 11/28/2023