RE: how to store orace errors in database

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Thu, 22 Mar 2001 00:43:57 -0800
Message-ID: <F001.002D4763.20010322001937@fatcity.com>

When connected to Oracle on NT, I use following command to get Oracle Error messages. I have saved the content as oerr.sql file in bin directory and run @oerr from SQL prompt ....

>>>>>>>>>>>

rem

---

rem Filename: oerr.sql
rem Purpose: Lookup Oracle error messages. Similar to unix "oerr" command.
rem This script is handy on platforms like NT with no OERR support
rem Author: Frank Naude (frank_at_onwe.co.za) rem
rem modified by Rajesh Dayal to avoid entering negative number

---

set serveroutput on
set veri off feed off
prompt Lookup Oracle error messages:
prompt
exec dbms_output.put_line('==> '||sqlerrm( (-1) * &errno ) ); set veri on feed on
undef errno

<<<<<<<<<<<<

PS: I don't take any credit for above, just modified it a bit ;-))

HTH,
Rajesh

-----Original Message-----
Sent: Thursday, March 22, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L

Hello I am Kaushik Das from india .I am new to your group. I had a query ,i hope some one will reply to this mail.

Just like we can store help of sql commands in HELP table in oracle database.In a semilar way can we store ORACLE errors in database

for example to see oracle error 0000 in unix we write oerr ora 0000

1)what command should we write in nt to see the complete info of this error.

2) How to store and retrive complete oracle error messages in oracle database.

3) is there any sql file which dba should run to create such table and toad
data.

Thanks in advance.

regards

kaushik

---

---
--------------------------------------------
IFFCO's Website Address  -   www.iffco.nic.in


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: kaushikdas
  INET: kaushikdas/iffco_at_iffco.nic.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajesh Dayal
  INET: Rajesh_at_ohitelecom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Mar 22 2001 - 02:43:57 CST