Re: Identifying problem SQL statements

Hi

    you can use when others exception .

        log SQLERRM to some place which will direct you which statement is failing in your procedure. Also make your procedure more modular so that you will have fine granularity for debugging purpose..

    hope it help..
pradhan

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 Wed Jan 27 1999 - 23:23:13 CST