Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL Find out last SQL run

PL/SQL Find out last SQL run

From: <pwu_at_qantas.com.au>
Date: 15 Mar 2005 20:20:24 -0800
Message-ID: <1110946824.246812.138890@o13g2000cwo.googlegroups.com>


Hi,
I want to print out the last sql I ran in a general purpose exception handling routine for debugging purposes.

I know that I can print out the call stack from PL/SQL and this would give me a good idea what sql that was run that caused the exception.

I know that there is a showsql PL/SQL program that shows the sql run by active users of the instance. However the act of reading the sql is an sql itself and so this program would show the inquiring sql rather than the sql causing the exception.

Anyone have any ideas how to get the last sql I ran?

Thanks for any assistance Received on Tue Mar 15 2005 - 22:20:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US