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 -> how to get the most recent sqlstatement

how to get the most recent sqlstatement

From: Maija-Leena Kangasmäki <maija-leena.kangasmaki_at_tieto.com>
Date: Tue, 09 Mar 1999 12:19:52 GMT
Message-ID: <36E5119E.B0EDC7C5@tieto.com>


Hi,

is there a way to get the most recent sqlstatement ?

I'm debugging an error that updates too many rows in the database but I don't know the program which does it. Is there any way to find out the sqlstatement in table trigger ? Any other suggestions ? I tried to use audit and saving new and old values to another table but that doesn't tell much.

Regards,

Maija-Leena Received on Tue Mar 09 1999 - 06:19:52 CST

Original text of this message

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