Re: To capture the SQL that raised the exception

From: Tim Gorman <tim_at_evdbt.com>
Date: Fri, 26 Oct 2012 17:54:51 -0600
Message-ID: <508B22CB.7030405_at_evdbt.com>

If the exception handling is the default and hasn't been customized, then the standard error messages cite a line number, which you can find in the DBA_SOURCE view for that program module, which will locate the SQL statement within the function, procedure, or package.

On 10/26/2012 4:17 PM, anuragdba_at_gmail.com wrote:
> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Oct 27 2012 - 01:54:51 CEST