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>