SQLPlus Whenever Sqlerror
WHENEVER SQLERROR Command Syntax:
WHENEVER SQLERROR
{EXIT [SUCCESS|FAILURE|WARNING|n|variable|:BindVariable]
[COMMIT|ROLLBACK]|CONTINUE [COMMIT|ROLLBACK|NONE]}
WHENEVER SQLERROR Command Examples:
WHENEVER SQLERROR EXIT SQL.SQLCODE
select no_column from dual;
WHENEVER SQLERROR EXIT SQL.SQLCODE
Begin
SELECT NO_COLUMN FROM DUAL;
End;
/