Re: oerr

From: <markp7832_at_my-deja.com>
Date: Thu, 03 Jun 1999 14:06:29 GMT
Message-ID: <7j624u$g69$1@nnrp1.deja.com>

In article <3756760a.0_at_145.227.194.253>,   "Mark Gumbs" <mgumbs_at_nospam.hotmail.com> wrote:
> There is a free utility for Windows, OraCodes, Written by Gerrit Jan-
Linker.
> You supply an oracle error code and up pops a description.
>
> I can't remember the website, but you can find it via Yahoo
>
> Mark
>
> I.A. Saez Scheihing wrote in message <375661BA.392851C3_at_tue.nl>...
> >
> >
> >Probably it is Not There :-)
> >
> >
> >
> >Steven Egberghs wrote:
> >
> >> Hi there
> >> I know that on Unix you could get some more explanation of an
oracle
> error
> >> by typing
> >> oerr ORA 1234
> >>
> >> How is this done on NT (Oracle8)
> >> Thanks
> >

This is not as good as oerr nor the mentioned utility (which I have never seen,) but it is better than nothing when a manual is not handy:

I call the script ora_error.sql and it is in a developer accessible directory.
set echo off
rem
rem Pl/sql script to create procedure to report Oracle error messages rem in sqlplus
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

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 03 1999 - 09:06:29 CDT