If value IS NULL, raise exception
SQL>
SQL> DECLARE
2 lv_general_excep EXCEPTION;
3 BEGIN
4 IF NULL IS NULL THEN
5 RAISE lv_general_excep;
6 ELSE
7 -- Process Logic
8 NULL;
9 END IF;
10 EXCEPTION
11 WHEN lv_general_excep THEN
12 NULL;
13 END;
14 /
PL/SQL procedure successfully completed.
SQL>
Related examples in the same category