Identifying problem SQL statements

From: <lofftjm_at_itec.suny.edu>
Date: Thu, 28 Jan 1999 02:27:52 GMT
Message-ID: <78ohv1$5ug$1@nnrp1.dejanews.com>

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 Wed Jan 27 1999 - 20:27:52 CST