Have you tried the ora_sql_txt event ?
hth
connor
--- david hill [EMAIL PROTECTED] wrote: Hi
Guys, I was wondering if someone could help me
I'm trying to create an AFTER SERVERERROR trigger
that will log all errors
and the SQL that caused the error.
Here's what I have so far
Hi Guys, I was wondering if someone could
help me
I'm trying to create an AFTER
SERVERERROR trigger that will log all errors and the SQL that caused the error.
Here's what I have so far
CREATE OR REPLACE TRIGGER server_error_trig
AFTER SERVERERROR ON DATABASE
DECLARE text
David,
I have tried to get the previous SQL on a number of versions and I
have always found the address and hash value pretty buggy - usually the
same as the current SQL. Moreover, SQL statements which have failed are
usually pretty hard to catch (no mention in V$SQLAREA, for what I know).
I