Re:how to store orace errors in database

From: <dgoulet_at_vicr.com>
Date: Thu, 22 Mar 2001 07:43:24 -0800
Message-ID: <F001.002D4BEB.20010322063553@fatcity.com>

Kaushik,

There is nothing that I know of that does a help_table for error messages. One can use the selerrm function to return the text of any error although it does not send back the reason why nor the corrective action. I'm not sure about NT and oerr. I haven't found it yet there, but then I don't use NT as a db server platform.

Dick Goulet

____________________Reply Separator____________________
Author: "kaushikdas" <kaushikdas/iffco_at_iffco.nic.in>
Date:       3/21/2001 11:35 PM

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:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------