Re: How to find out what error msg's mean

Ron, you need to find the documentation CD that came with your system and have it installed on the lan, but here is some code that will give you the short text that appears with the ORA-xxxxx number. In some cases it is enough.

DDC2> _at_/usr/local/dba/sql/ora_error
Enter Oracle Error Number, i.e, ORA-00100 = 100 ==> 100 ORA-00100: no data found

DDC2> /
Enter value for err_code: 01014
ORA-01014: ORACLE shutdown in progress

PL/SQL procedure successfully completed.

set echo off
rem
rem Pl/sql script to create procedure to report Oracle error messages rem in sqlplus
rem
rem 1996 07 11 m d powell New script. rem 1998 06 23 m d powell Modify to be in-stream procedure from stored rem
set feedback off
set serveroutput on
set verify off
accept err_code prompt "Enter Oracle Error Number, i.e, ORA-00100 = 100 ==> "
declare
procedure ora_error (
  v_err_no in number
  )
is

v_rc       number              ;
v_msg      varchar2(100)       ;

--
begin
if  v_err_no  >  0  then
  v_rc  :=  v_err_no * -1      ;
else
  v_rc  :=  v_err_no           ;
end if                         ;
v_msg  :=  sqlerrm(v_rc)       ;
dbms_output.put_line(v_msg)    ;
end ora_error                  ;
--
begin
 ora_error(&err_code);
end;
/
set feedback     on
undefine err_code

Ron Lendon <rlendon_at_ameritech.net> wrote in article
<bLH32.2023$ZP5.4765348_at_nntp0.detroit.mi.ameritech.net>...


> I have a need to discover what the Oracle errors are. i.e.  When Oracle


> returns ORA-##### I want to be able to type in the number and receive the

> text of what the error is.  In AIX there is the oerr command.  I need the

> same functionality in NT 4.0.

> 

> I have no books and am supporting 90 installations of Oracle, most are

> running on NT 4.0.  Many times my users are calling our help desk just to

> find out what the error message means.  I think there may be a lookup

table


> but just don't know where it is or how to access it.


> 

> Thanks,

> Ron Lendon

> rlendon_at_ameritech.net

> 

> 

> 

>