Re: Are Oracle error messages kept in a SYS table?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 20 Sep 2007 11:03:23 -0700
Message-ID: <1190311403.836418.58400@g4g2000hsf.googlegroups.com>

On Sep 20, 1:04 pm, "Terry Dykstra" <tddyks..._at_forestoil.ca> wrote:
> I'm using 9207.
> --
> Terry Dykstra

No. The error messages are contained in an OS file located in the $ORACLE_HOME/rdbms/mesg directory most likely oraus.msg

You can obtain error messages in SQLPlus via the following code:

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
rem

---

rem 1996 07 11 m d powell New script. rem 1998 06 23 m d powell Modify to be in-stream procedure from stored
rem
set feedback off
set serveroutput on
set verify off
accept err_code prompt "Enter Oracle Error Number, i.e, ORA-00100 = 100 ==> "
declare
procedure ora_error (
  v_err_no in number
  )
is

v_rc       number              ;
v_msg      varchar2(100)       ;

--
begin
if  v_err_no  >  0  then
  v_rc  :=  v_err_no * -1      ;
else
  v_rc  :=  v_err_no           ;
end if                         ;
v_msg  :=  sqlerrm(v_rc)       ;
dbms_output.put_line(v_msg)    ;
end ora_error                  ;
--
begin
 ora_error(&err_code);
end;
/
set feedback     on
undefine err_code

HTH -- Mark D Powell --

Received on Thu Sep 20 2007 - 13:03:23 CDT