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: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: 1997/04/06
Message-ID: <3347CA33.4944@exesolutions.com>#1/1

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

I may be shown to be incorrect by those more knowledgeable than I but I suspect it can not be done without forcing those doing the queries through some kind of three tier system where the middle tier does the capture.

Daniel A. Morgan Received on Sun Apr 06 1997 - 00:00:00 CST

Original text of this message

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