Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get text of Last SQL Query

317179Aug 1 2002
Sorry if this has been covered, but the search page keeps erring on me.

I am trying to figure out how to get the text of the last SQL statement executed (succesfully or unsuccesfully) by my current login.
What it is, is i want in the exception handler of my procedure to be able to dump the text of the Query which was last run into the log file.
Any help with this will be greatly appreciated!
Thanks in advance,

Aaron.
aabdis@mecnet.com
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2002
Added on Aug 1 2002
4 comments
742 views