Define and use your own exception : Your own Exception « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Your own Exception

Define and use your own exception


SQL>
SQL> -- define and use your own exception
SQL>
SQL>
SQL>  declare
  2      CHILD_ERROR exception;
  3    begin
  4      raise CHILD_ERROR;
  5    end;
  6    /
 declare
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 4


SQL>








Related examples in the same category

1.How to define your own exception
2.used defined exception
3.Using SQLCODE and SQLERRM
4.Handling a user-defined exception
5.Raise User-defined exceptions
6.Insert Exception message to an audit table