Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gBCH5J616731 for ; Thu, 12 Dec 2002 11:05:19 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gBCH5I316724 for ; Thu, 12 Dec 2002 11:05:18 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id FAA19385; Thu, 12 Dec 2002 05:44:45 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00518802; Thu, 12 Dec 2002 05:23:51 -0800 Message-ID: Date: Thu, 12 Dec 2002 05:23:51 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Jamadagni, Rajendra" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Jamadagni, Rajendra" Subject: RE: ora_sql_txt system defined event attribute Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPartTM-000-bd6f4ff7-00be-4421-a6d0-9de1a25cfa77" ------=_NextPartTM-000-bd6f4ff7-00be-4421-a6d0-9de1a25cfa77 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2A1E1.56234220" ------_=_NextPart_001_01C2A1E1.56234220 Content-Type: text/plain; charset="iso-8859-1" It (ora_sql_text) won't work in 8i .. but in 9202 it works fine, I think it was introduced in 8i, but extended in 9i... I am not yet using dbms_system.ksdwrt in prod but on our ACPT instances, I use it to capture all the DDL that happens in the database. Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -----Original Message----- Sent: Wednesday, December 11, 2002 4:59 PM To: Multiple recipients of list ORACLE-L 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 ... ------_=_NextPart_001_01C2A1E1.56234220 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: ora_sql_txt system defined event attribute

It (ora_sql_text) won't work in 8i .. but in 9202 it = works fine, I think it was introduced in 8i, but extended in 9i... =

I am not yet using dbms_system.ksdwrt in prod but on = our ACPT instances, I use it to capture all the DDL that happens in the = database.

Raj
______________________________________________________
Rajendra = Jamadagni          &nb= sp;   MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't = reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion = is an art!
-----Original Message-----
From: Casey Dyke [mailto:cdyke@corp.home.nl]=
Sent: Wednesday, December 11, 2002 4:59 PM
To: Multiple recipients of list ORACLE-L
Subject: ora_sql_txt system defined event = attribute


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

------_=_NextPart_001_01C2A1E1.56234220-- ------=_NextPartTM-000-bd6f4ff7-00be-4421-a6d0-9de1a25cfa77 Content-Type: text/plain; name="ESPN_Disclaimer.txt" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="ESPN_Disclaimer.txt" *********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1 ------=_NextPartTM-000-bd6f4ff7-00be-4421-a6d0-9de1a25cfa77-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni@espn.com 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@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).