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

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Wed, 13 Jun 2007 20:40:00 +0800
Message-ID: <00ab01c7adb7$f7229e50$0300a8c0@dell600m>

as well as format_error_backtrace in v10, plus a whole shedload of various attributes available from SYS_CONTEXT('USERENV','...')

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gints Plivna
Sent: Tuesday, 12 June 2007 10:56 PM
To: Krishnadas.Chathamath_at_iflexsolutions.com Cc: oracle-l_at_freelists.org
Subject: Re: How to find out the last executed sql statement....

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 Wed Jun 13 2007 - 07:40:00 CDT