Reading this I am wondering why you are not using the dbms_application_info
package procedures set_module, set_action and set_client_info. This is the
native utility that Oracle provides to help track what is going on in your
application.
On 6/12/07, Kerber, Andrew W. <Andrew.Kerber_at_umb.com> wrote:
>
> The only way I know if is to output each statement using some form of an
> output command. Utl file is kind of cumbersome, you could do
> dbms_output.put_line.
>
>
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *
> Krishnadas.Chathamath_at_iflexsolutions.com
> *Sent:* Tuesday, June 12, 2007 7:43 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* How to find out the last executed sql statement....
>
>
>
> Hi,
>
>
>
> I am a new member of oracle-l and I am finding it very helpful.
>
>
>
> We are trying to make our Application debug easier.
>
> Currently we write debug messages to a file using utl_file package during
> the application's execution.
>
> So we can find out till the position where the application runs
> successfully and where it fails and why it fails (error messages) by looking
> into the debug file.
>
>
>
> Now we are thinking to modify the application debug as follows,
>
>
>
> Once the functionality fails we will insert the Session id, Package name
> and last executed sql (Failed SQL statement or Last successful statement) in
> a table and from there the developers can get the details. So we need not
> looking into the debug file at the initial stage.
>
>
>
> But how to get the last executed sql statement?
>
>
>
> Please help us with your valuable suggestions.
>
>
>
> Thanks & Regards
>
> Krishnadas C.K
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> NOTICE: This electronic mail message and any attached files are
> confidential. The information is exclusively for the use of the individual
> or entity intended as the recipient. If you are not the intended recipient,
> any use, copying, printing, reviewing, retention, disclosure, distribution
> or forwarding of the message or any attached file is not authorized and is
> strictly prohibited. If you have received this electronic mail message in
> error, please advise the sender by reply electronic mail immediately and
> permanently delete the original transmission, any attachments and any copies
> of this message from your computer system. Thank you.
>
>
> ==============================================================================
>
--
Rumpi Gravenstein
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 12 2007 - 08:47:05 CDT
