hiya folks,
just curious whether anyone is successfully using this attribute w/servererror trigger to capture the sql for a failed transaction -- say for a 1555 error?
it would appear to be new to 9i as i can see it in the doco for 9.2 and not 8i. furthermore, the event is simply not defined in dbms_system w/in my 8i rdbms/admin dir (dbmsstdx.sql/dbmstrig.sql).
after an admittedly brief faff about w/v$session/v$open_cursor & prev_sql_addr/prev_hash_value in 8i (ie: not this fancy new function) it would appear that i capture code from the servererror trigger itself (say something like 'select userenv('sessionid') ...) - rather than the offending sql code. not exactly what i am looking for. but maybe i ain't working hard enough ...
also, how many out there use dbms_system.ksdwrt in prod? works fine in dev for me ...
cheers,
casey ...
