It performs the specified action (exits SQL*Plus by default) if a SQL command or PL/SQL block generates an error.
WHENEVER SQLERROR
{
EXIT [SUCCESS|FAILURE|WARNING|n|variable|:BindVariable][COMMIT|ROLLBACK]
|
CONTINUE [COMMIT|ROLLBACK|NONE]
}
where:
WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK