Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to capture SQL_TEXT of queries?

Re: How to capture SQL_TEXT of queries?

From: Michael Ho <infoage_at_hk.super.net>
Date: 1997/04/06
Message-ID: <3347C04F.299E@hk.super.net>#1/1

Dragon Fly wrote:
>
> In short, I need to set up kind of a trigger
> on some of the tables so that it captures the
> text of the queries run against those tables.
> The problem is, the "standard"
> triggers can be set up only for UPDATE OR INSERT
> while I need a trigger for SELECT statement.
> Anybody has an idea what is the good way of implementing
> such kind of thing?

Never heard trigger on select. Only heard event tracing, but I don't think it is something you want. Received on Sun Apr 06 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US