RE: data dictionary view with all oracle errors in it?

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 27 Jul 2004 13:51:31 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DE30@usahm018.exmi01.exch.eds.com>

Here is a simple script for when you want to know a specific error.

set echo off
rem
rem Pl/sql script to create procedure to report Oracle error messages rem in sqlplus
rem
rem Note - you can in sqlplus issue:

rem       set serveroutput on
rem       execute dbms_output.put_line(sqlerrm(-01017))

rem
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 =3D = 100
=3D=3D> "
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 :=3D v_err_no * -1 ;
else

  v_rc  :=3D  v_err_no           ;
end if                         ;
v_msg  :=3D  sqlerrm(v_rc)       ;
dbms_output.put_line(v_msg)    ;
end ora_error                  ;

--

begin
 ora_error(&err_code);
end;
/
set feedback on
undefine err_code

-----Original Message-----

From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tanel P=F5der
Sent: Tuesday, July 27, 2004 11:44 AM
To: oracle-l_at_freelists.org
Subject: Re: data dictionary view with all oracle errors in it?

Someone once posted here a cool script to retrieve the Oracle errors = (also
event descriptions) in PL/SQL:

SET SERVEROUTPUT ON

     DECLARE
       err_msg VARCHAR2(1000);
     BEGIN
       dbms_output.enable (1000000);
       FOR err_num IN 10000..11005


--       FOR err_num IN 38001..39000

       LOOP
         err_msg :=3D SQLERRM (-err_num);
         IF err_msg NOT LIKE '%Message '||err_num||' not found%' THEN
           dbms_output.put_line (err_msg);
         END IF;
       END LOOP;
     END;

/

Tanel.

• Original Message -----=20 From: <J.Velikanovs_at_alise.lv> To: <oracle-l_at_freelists.org> Sent: Tuesday, July 27, 2004 6:24 PM Subject: Re: data dictionary view with all oracle errors in it?

> Unix
> oerr ora 903
> vi $ORACLE_HOME/rdbms/mesg/oraus.msg
>
> Jurijs
> 9268222
> =

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

> http://otn.oracle.com/ocm/jvelikanovs.html
>
>
>
>
>
>
> ryan.gaffuri_at_comcast.net
> Sent by: oracle-l-bounce_at_freelists.org
> 27.07.2004 18:26
> Please respond to oracle-l
>
>         To:     oracle-l_at_freelists.org
>         cc:
>         Subject:        data dictionary view with all oracle errors =

in it?

>
>
> I believe there is a view that will have all of the oracle errors =

listed
> in it. I am not talking about dba_errors which has all the current = errors.
> Just a lookup of Oracle errors.
> One of the guys here says there is one, but can't remember which one = it
> is. Anyone know?

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Jul 27 2004 - 12:49:06 CDT