SQL>DECLARE
2 err_msg VARCHAR2(120);
3 BEGIN
4 dbms_output.enable (1000000);
5 FOR err_num IN 10000..10999
6 LOOP
7 err_msg := SQLERRM (-err_num);
8 IF err_msg NOT LIKE '%Message '||err_num||' not found%' THEN
9 dbms_output.put_line (err_msg);
10 END IF;
11 END LOOP;
12 END;
13 /
2 err_msg VARCHAR2(120);
3 BEGIN
4 dbms_output.enable (1000000);
5 FOR err_num IN 10000..10999
6 LOOP
7 err_msg := SQLERRM (-err_num);
8 IF err_msg NOT LIKE '%Message '||err_num||' not found%' THEN
9 dbms_output.put_line (err_msg);
10 END IF;
11 END LOOP;
12 END;
13 /