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





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>










24.17.raise_application_error
24.17.1.Using RAISE_APPLICATION_ERROR
24.17.2.Raise applocation error
24.17.3.A complete example using RAISE_APPLICATION_ERROR
24.17.4.Check the result of count aggregation function and then raise exception
24.17.5.Use RAISE_APPLICATION_ERROR to re throw exceptions