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

  • From: "Rumpi Gravenstein" <rgravens@xxxxxxxxx>
  • To: Krishnadas.Chathamath@xxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 12 Jun 2007 09:47:05 -0400

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@xxxxxxx> 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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *
Krishnadas.Chathamath@xxxxxxxxxxxxxxxxxx
*Sent:* Tuesday, June 12, 2007 7:43 AM
*To:* oracle-l@xxxxxxxxxxxxx
*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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2007