Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Identifying problem SQL statements

Re: Identifying problem SQL statements

From: Em Pradhan <empradhan_at_dplus.net>
Date: Thu, 28 Jan 1999 00:23:13 -0500
Message-ID: <36AFF441.B0967999@dplus.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US