Re: Oracle Statement Parser

Hi:

You could *sniff* the IP packets at the network level, but right off, I'd say you'll have a much easier time simply retrieving them from the V$SQL dynamic table after they've parsed. Of course, if you are constructing a commercial app that will intercept SQL statements and pre-optimize them, then getting them from V$SQL won't do you much good. The packets sent via SQL*Net can be concatenated and read if sniffed IF you not using some of the more advanced security functions (most people don't). You could probably most easily trap them by grabbing everything going to the IP address of the box hosting the database instance.

Good luck,
Dave

Reinhard Prehofer wrote in message <35CF0B02.153E880E_at_cet.co.at>...
>Hi all,
>who can give me a hint on how to catch SQL-Statements just before they
>hit the SQL-Engine of Oracle (rather version 7.3 than 8.x) and are
>executed.
>Since that statement parser should work for ANY client connecting to the
>database via sql*net (>= v2.3) we are rather sure that this parser would
>have to sniff the sql*net strings.
>
>thanks in advance and regards,
>
> reinhard.prehofer_at_cet.co.at
Received on Mon Aug 10 1998 - 16:57:43 CDT