To capture the SQL that raised the exception

From: <anuragdba_at_gmail.com>
Date: Fri, 26 Oct 2012 15:17:01 -0700
Message-Id: <402923F1-CB8F-4B4F-BFF3-6C7FF8A16F6C_at_gmail.com>

Hi all,

A quick question on PL/SQL exception handling....

Is there a way to capture the SQL that raised the exception?

I have used SQLCODE and SQLERRM, but both do not help to get the SQL that is causing the exception...

Thanks,
Anurag--
http://www.freelists.org/webpage/oracle-l Received on Sat Oct 27 2012 - 00:17:01 CEST

This message: [ Message body ]
Next message: Tim Gorman: "Re: To capture the SQL that raised the exception"
Previous message: Mek S: "Hugepages setup OEL6"
Next in thread: Tim Gorman: "Re: To capture the SQL that raised the exception"
Reply: Tim Gorman: "Re: To capture the SQL that raised the exception"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message