db oracle error_list

oracle 文档

http://www.oracle.com/technology/documentation/database10gr2.html

Oracle Database 10g Release 2 Documentation Library

Part Number	Link	Download	Description
B19306-01	View Library	Download (445.8MB)	Documentation library for Oracle Database

Oracle Database 10g Lite Documentation Library

Part Number Link Download Description

B19188-01	View Library	Download (15 MB)	Documentation library for Oracle Database Lite

取oracle的error code 错误码查询

oerr - Oracle Error Code Lookup 20090424 / firefox search 插件

https://addons.mozilla.org/zh-CN/firefox/addon/11641

oracle 9i错误代码查询书

http://www.ixpub.net/viewthread.php?tid=894178&pid=8079387&page=1&extra=#pid8079387

http://www.ixpub.net/attachment.php?aid=561448&k=e1ad1c032ff9caa51b455fe162d4d127&t=1253264288&ck=0f28a96d&sid=41faJgW8TvspEtwfoyD1T7uYjnz5RFNvm7%2F1s%2FyDxXSA8j4

辅助开发工具 oracle 错误代码查询

http://www.oracle.com.cn/viewthread.php?tid=142070&pid=1097754&page=1&extra=#pid1097754

http://www.oracle.com.cn/attachment.php?aid=61153

http://tahiti.oracle.com/

http://www.ora-code.com/ 或 http://ora-12537.ora-code.com

http://dolphin-ygj.iteye.com/blog/361948

http://clarancepeng.iteye.com/blog/118394

file:///E:/program/database/Oracle/oracle%20doc/oracle-err-code.html

E:\program\database\Oracle\oracle doc\oracle错误代码和信息速查手册.chm

http://dl.iteye.com/topics/download/db9f7833-9fb3-4cfe-aae6-a4723c135ff2

http://dl.iteye.com/topics/download/c10f2b24-21d7-3a3b-a6e3-5740bcd828de

有时候需要知道oracle的error code的具体含义， 但总是找不全 不过可以通过以下方式直接从oracle数据库本身获得：

Sql代码

create type t_oracle_error is object (
error_num varchar2(9),
error_desc varchar2(1024)
);
create type t_oracle_error_tab is table of t_oracle_error;

create or replace function OracleErrors return t_oracle_error_tab pipelined is
  l_error t_oracle_error := t_oracle_error(null,null);
begin
  for errNo in reverse -32799..0 loop
    l_error.error_num := errNo;
    l_error.error_desc := sqlerrm(errNo);
    if l_error.error_desc not like '%Message % not found;%' and l_error.error_desc != 'ORA'||to_char(errNo,'FM09999')||': ' then
      pipe row(l_error);
    end if;
  end loop;
  return;
end OracleErrors;

select * from table(oracleerrors); 

一个简单的查询所有Oracle错误代码的语句

作者:fuyuncat
多年电信、航运行业经验的Oracle DBA

mail: [e-mail]; [e-mail]

msn:[e-mail] Home

Page: http://www.HelloDBA.com/

http://fuyuncat.itpub.net/post/5203/64265

begin
dbms_output.enable(1000000);
for i in 0..10000 loop
dbms_output.put_line(SQLERRM(0-i));
end loop;
dbms_output.disable();
dbms_output.enable(1000000);
for i in 10001..20000 loop
dbms_output.put_line(SQLERRM(0-i));
end loop;
end;/

 

 

end