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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Gints Plivna Sent: Tuesday, 12 June 2007 10:56 PM To: Krishnadas.Chathamath@xxxxxxxxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxxxxxxx > But how to get the last executed sql statement? -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l