SQL> DECLARE 2 ERR_MSG VARCHAR2 (120); 3 Begin4 dbms_output.enable (1000000); 5 for err_num in 10000..109996 loop7 err_msg: = sqlerrm (-ERR_NUM); 8 if err_msg not like '% Message' || err_num | | 'NOT FOUND%' TEN9 DBMS_OUTPUT.PUT_LINE (ERR_MSG); 10 End IF; 11 End Loop; 12 End; 13 /
