ora_sql_txt system defined event attribute

From: Casey Dyke <cdyke_at_corp.home.nl>
Date: Wed, 11 Dec 2002 13:58:55 -0800
Message-ID: <F001.00518036.20021211135855@fatcity.com>

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 ...

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Casey Dyke
  INET: cdyke_at_corp.home.nl

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Dec 11 2002 - 15:58:55 CST