Re: Identifying problem SQL statements

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Thu, 28 Jan 1999 23:33:04 +0000
Message-ID: <36B0F3B0.62DAC1CA@rdbms.freeserve.co.uk>

Joe

The error stack will have all the information you need. Check out the DBMS_UTILITY.FORMAT_ERROR_STACK function.

Chris.

lofftjm_at_itec.suny.edu wrote:
>
> I have a PL/SQL procedure that includes many insert and update
> statements. Instead of performing exception handling for each
> specific statement, is it possible to have a single WHEN OTHERS
> exception that will then show the SQL statement that caused the
> problem?
>
> I have looked at V$SQLTEXT, V$SQLAREA and a few other tables but
> I have been unsuccessful in determining which SQL statement
> caused the error.
>
> Thanks in advance for any help.
>
> Joe Lofft
> lofftjm_at_itec.suny.edu
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Jan 28 1999 - 17:33:04 CST