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 "RNTSOFT.REGISTER", line 3
SQL>