Snooping the SQL issued by a client app

From: CUJimmy <public_at_asd-group.com>
Date: Thu, 19 Oct 2000 20:59:25 GMT
Message-ID: <8snnb8$l99$1@nnrp1.deja.com>

I'm not a database/Oracle expert, but I have a custom 16-bit Windows program which extracts data from an Oracle 8i database (through SQLnet) to local files. It does this using embedded SQL and calls some stored procedures in the database.

I need to find out what SQL it generates (directly or via stored procedures) while it runs, so I can ultimately figure out what it does and write an ODBC version of the same thing (unfortunately it has no docs or source code).

Could someone tell me if there is a way to snoop the program in this manner? I'm hoping that there is some Oracle or SQL-Net mode, or other tool, which can dump the SQL sent from the client, or something like that.

Thanks for any suggestions!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 19 2000 - 15:59:25 CDT