ORACLE 查询Oracle错误码
1.创建一个表存储错误码
SQL> create table dict_errordesc(eno integer primary key, emsg long);Table created
create or replace procedure createErrorDesc is msg long; status integer;begin-- insert tabledbms_output.enable(1000000);for i in 0..10000 loop dbms_output.put_line(SQLERRM(0-i)); dbms_output.get_line(msg, status); insert into dict_errordesc values(i, msg);end loop;dbms_output.disable();dbms_output.enable(1000000);for i in 10001..20000 loop dbms_output.put_line(SQLERRM(0-i)); dbms_output.get_line(msg, status); insert into dict_errordesc values(i, msg);end loop;-- commitcommit; end createErrorDesc;
SQL> set serveroutput onSQL> exec createErrorDescPL/SQL procedure successfully completed
SQL> select count(*) from dict_errordesc; COUNT(*)---------- 20001SQL> select * from dict_errordesc where rownum <= 10; ENO EMSG--------------------------------------- -------------------------------------------- 0 ORA-0000: normal, successful completion 1 ORA-00001: 违反唯一约束条件 (.) 2 ORA-00002: Message 2 not found; product=RDBMS; facility=ORA 3 ORA-00003: Message 3 not found; product=RDBMS; facility=ORA 4 ORA-00004: Message 4 not found; product=RDBMS; facility=ORA 5 ORA-00005: Message 5 not found; product=RDBMS; facility=ORA 6 ORA-00006: Message 6 not found; product=RDBMS; facility=ORA 7 ORA-00007: Message 7 not found; product=RDBMS; facility=ORA 8 ORA-00008: Message 8 not found; product=RDBMS; facility=ORA 9 ORA-00009: Message 9 not found; product=RDBMS; facility=ORA10 rows selected
