Re: data dictionary view with all oracle errors in it?
- From: J.Velikanovs@xxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Jul 2004 18:41:33 +0300
Really cool block :)
I appreciate it.
THX.
Jurijs
9268222
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
Tanel Põder <tanel.poder.003@xxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
27.07.2004 18:43
Please respond to oracle-l
To: <oracle-l@xxxxxxxxxxxxx>
cc:
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 := 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 -----
From: <J.Velikanovs@xxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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
> ============================================
> http://otn.oracle.com/ocm/jvelikanovs.html
>
>
>
>
>
>
> ryan.gaffuri@xxxxxxxxxxx
> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
> 27.07.2004 18:26
> Please respond to oracle-l
>
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts: