Re: data dictionary view with all oracle errors in it?
- From: J.Velikanovs@xxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Jul 2004 19:05:09 +0300
Enjoy.
I have used Tanel posted code. Thanks Tanel again.
SYS:POL01> select * from edu_oerr where rownum < 11;
ERR_MSG
---------------------------------------------------------------------------------
ORA-0000: normal, successful completion
ORA-00001: unique constraint (.) violated
ORA-00017: session requested to set trace event
ORA-00018: maximum number of sessions exceeded
ORA-00019: maximum number of session licenses exceeded
ORA-00020: maximum number of processes () exceeded
ORA-00021: session attached to some other process; cannot switch session
ORA-00022: invalid session ID; access denied
ORA-00023: session references process private memory; cannot detach
session
ORA-00024: logins from more than one process not allowed in single-process
mode
10 rows selected.
SYS:POL01>
drop type edu_text;
drop function edu_oerr_f;
drop view edu_oerr;
CREATE OR REPLACE type edu_text as table of varchar2(4000);
/
create or replace function edu_oerr_f
return edu_text pipelined
as
err_msg VARCHAR2(1000);
BEGIN
FOR err_num IN 0..11005
LOOP
err_msg := SQLERRM (-err_num);
IF err_msg NOT LIKE '%Message '||err_num||' not found%' THEN
pipe row (err_msg);
END IF;
END LOOP;
return;
END;
/
create or replace view edu_oerr as select COLUMN_VALUE err_msg from
table(edu_oerr_f);
select * from edu_oerr;
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:
