Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can we capture all errors through SQLERRM ?
Hi Krishna
Try
FORMAT_ERROR_STACK Function
This function formats the current error stack. This can be used in exception
handlers to look at the full error stack.
Syntax
DBMS_UTILITY.FORMAT_ERROR_STACK RETURN VARCHAR2;
Parameters
None.
Returns
This returns the error stack, up to 2000 bytes.
Krishna Kakatur wrote:
Hi,
How can I capture the second error message (ORA-06512: at line 4) in
Exception handler? I want to capture all the messages and insert them
into
Error Log table.
ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 4 ------------------------------------------------------------------SQL> declare
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishna KakaturReceived on Wed Jun 13 2001 - 16:56:34 CDT
INET: master_dba_at_hotmail.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). -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107
smime.p7s