From Rajesh@ohitelecom.com Thu, 22 Mar 2001 00:43:57 -0800 From: Rajesh Dayal Date: Thu, 22 Mar 2001 00:43:57 -0800 Subject: RE: how to store orace errors in database Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@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@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@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@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).