The database on error exception condition occurs when the Database
  Control System (DBCS) encounters any database exception condition for
  any Data Manipulation Language (DML) statement.

  The ON ERROR phrase in a DML statement allows the selection of an
  imperative statement sequence when any database exception condition
  occurs.

  Format -

   ON ERROR stment