Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gBK8NcR24437 for ; Fri, 20 Dec 2002 02:23:38 -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 gBK8Ncc24432 for ; Fri, 20 Dec 2002 02:23:38 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id VAA40100; Thu, 19 Dec 2002 21:06:34 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0051F414; Thu, 19 Dec 2002 20:23:57 -0800 Message-ID: Date: Thu, 19 Dec 2002 20:23:57 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Shaleen" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Shaleen" 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/alternative; boundary="----=_NextPart_000_034F_01C2A79C.56B0CF80" ------=_NextPart_000_034F_01C2A79C.56B0CF80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: ora_sql_txt system defined event attributecouldn't find anything abt = ora_sql_text on metalink. What is this? How do you capture ddl from = ksdwrt? Thanks Shaleen ----- Original Message -----=20 From: Jamadagni, Rajendra=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, December 12, 2002 5:23 AM Subject: 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...=20 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=20 ______________________________________________________=20 Rajendra Jamadagni MIS, ESPN Inc.=20 Rajendra dot Jamadagni at ESPN dot com=20 Any opinion expressed here is personal and doesn't reflect that of = ESPN Inc.=20 QOTD: Any clod can have facts, but having an opinion is an art!=20 -----Original Message-----=20 From: Casey Dyke [mailto:cdyke@corp.home.nl]=20 Sent: Wednesday, December 11, 2002 4:59 PM=20 To: Multiple recipients of list ORACLE-L=20 Subject: ora_sql_txt system defined event attribute=20 hiya folks,=20 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 ...=20 cheers,=20 casey ...=20 ------=_NextPart_000_034F_01C2A79C.56B0CF80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: ora_sql_txt system defined event = attribute
couldn't find anything abt ora_sql_text = on=20 metalink. What is this? How do you capture ddl from ksdwrt?
 
Thanks
Shaleen
----- Original Message -----
From:=20 Jamadagni, Rajendra =
Sent: Thursday, December 12, = 2002 5:23=20 AM
Subject: RE: ora_sql_txt system = defined=20 event attribute

It (ora_sql_text) won't work in 8i .. but in 9202 it = works=20 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=20 instances, I use it to capture all the DDL that happens in the = database.=20

Raj
______________________________________________________ =
Rajendra=20 = Jamadagni          &nbs= p;  =20 MIS, ESPN Inc.
Rajendra dot Jamadagni at = ESPN dot=20 com
Any opinion expressed here is personal = and doesn't=20 reflect that of ESPN Inc.
QOTD: Any clod can = have=20 facts, but having an opinion is an art!
-----Original=20 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=20 anyone is successfully using this attribute w/servererror trigger to = capture=20 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=20 for 9.2 and not 8i.  furthermore, the event is simply not defined = in=20 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=20 & prev_sql_addr/prev_hash_value in 8i (ie: not this fancy new = function) it=20 would appear that i capture code from the servererror trigger itself = (say=20 something like 'select userenv('sessionid') ...) - rather than the = offending=20 sql code.  not exactly what i am looking for. but maybe i ain't = working=20 hard enough ...

also, how many out there use dbms_system.ksdwrt in = prod? =20 works fine in dev for me ...
cheers, =
casey ...

------=_NextPart_000_034F_01C2A79C.56B0CF80-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shaleen INET: shgarg_orafaq@hotmail.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).