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 -----------------------------------------------------------------