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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to find out the last executed sql statement....

Re: How to find out the last executed sql statement....

From: Ajeet Ojha <ajeeto_at_gmail.com>
Date: Wed, 13 Jun 2007 10:01:51 +0530
Message-ID: <a8304bb50706122131u2d6d808cmc4814c08cb8e0aac@mail.gmail.com>


you can capture the module name as part of your error /excpetion handling mechnism.
ensure that you are giving correct program/module names using dbms_application_info.

Regards
Ajeet

On 6/12/07, Gints Plivna <gints.plivna_at_gmail.com> wrote:
>
> Are you aware also about dbms_utility.format_call_stack and
> format_error_stack?
>
> Gints Plivna
> http://www.gplivna.eu
>
> 2007/6/12, Krishnadas.Chathamath_at_iflexsolutions.com
> > But how to get the last executed sql statement?
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 12 2007 - 23:31:51 CDT

Original text of this message

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