 | | | data dictionary view with all oracle errors in it? | data dictionary view with all oracle errors in it? 2004-07-27 - By J.Velikanovs@(protected)
Enjoy.
I have used Tanel posted code. Thanks Tanel again.
SYS:POL01 > select * from edu_oerr where rownum < 11;
ERR_MSG
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
ORA-0000 (See ORA-0000.ora-code.com): normal, successful completion
ORA-00001 (See ORA-00001.ora-code.com): unique constraint (.) violated
ORA-00017 (See ORA-00017.ora-code.com): session requested to set trace event
ORA-00018 (See ORA-00018.ora-code.com): maximum number of sessions exceeded
ORA-00019 (See ORA-00019.ora-code.com): maximum number of session licenses exceeded
ORA-00020 (See ORA-00020.ora-code.com): maximum number of processes () exceeded
ORA-00021 (See ORA-00021.ora-code.com): session attached to some other process; cannot switch session
ORA-00022 (See ORA-00022.ora-code.com): invalid session ID; access denied
ORA-00023 (See ORA-00023.ora-code.com): session references process private memory; cannot detach
session
ORA-00024 (See ORA-00024.ora-code.com): 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@(protected) >
Sent by: oracle-l-bounce@(protected)
27.07.2004 18:43
Please respond to oracle-l
To: <oracle-l@(protected) >
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@(protected) >
To: <oracle-l@(protected) >
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@(protected)
> Sent by: oracle-l-bounce@(protected)
> 27.07.2004 18:26
> Please respond to oracle-l
>
> To: oracle-l@(protected)
> 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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|