Using RAISE_APPLICATION_ERROR : raise_application_error « PL SQL Programming « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Programming
3. raise_application_error

SQL>
SQL> CREATE OR REPLACE PROCEDURE Register is
  2  BEGIN
  3    RAISE_APPLICATION_ERROR(-20000, 'Can''t add more Employee');
  4
  5  EXCEPTION
  6    WHEN NO_DATA_FOUND THEN
  7      RAISE_APPLICATION_ERROR(-20001, ' doesn''t exist!');
  8  END Register;
  9  /

Procedure created.

SQL>
SQL> call Register();
call Register()
     *
ERROR at line 1:
ORA-20000: Can't add more Employee
ORA-06512: at "JAVA2S.REGISTER", line 3


SQL>