Create your own no_data_found EXCEPTION : Your Exception « PL SQL Programming « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Programming
3. Your Exception

SQL>
SQL>
SQL> DECLARE
  2     d VARCHAR2(1);
  3
  4     no_data_found EXCEPTION;
  5
  6  BEGIN
  7
  8     SELECT 'dummy' INTO d FROM dual WHERE 1=2;
  9
 10     IF d IS NULL
 11
 12     THEN
 13
 14        RAISE no_data_found;
 15
 16     END IF;
 17
 18  EXCEPTION
 19
 20     WHEN no_data_found
 21
 22     THEN
 23
 24        DBMS_OUTPUT.PUT_LINE ('Trapped the error!?');
 25  END;
 26  /
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 8


SQL>