Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: data dictionary view with all oracle errors in it?
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
v_rc number ; v_msg varchar2(100) ;
v_rc :=3D v_err_no ; end if ; v_msg :=3D sqlerrm(v_rc) ; dbms_output.put_line(v_msg) ; end ora_error ;
-----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.
> Unix > oerr ora 903 > vi $ORACLE_HOME/rdbms/mesg/oraus.msg > > Jurijs > 9268222 > =
> 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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
![]() |
![]() |