Re: How to vew SQL queries received from external application
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 6 Mar 2013 12:46:19 +0000 (UTC)
Message-ID: <kh7dqr$a5t$1_at_solani.org>
On Tue, 05 Mar 2013 16:32:19 -0800, Yaq wrote:
Date: Wed, 6 Mar 2013 12:46:19 +0000 (UTC)
Message-ID: <kh7dqr$a5t$1_at_solani.org>
On Tue, 05 Mar 2013 16:32:19 -0800, Yaq wrote:
> Hi, I'm new to Oracle and working a solution that having Oracle talks to
> an external application. The external application sends some sql queries
> to Oracle db. I don't own this external application, so I need to find
> out what exact sql queries are sent. Can anyone tell me how to view
> these queries please?
> Many thanks in advance.
You will have to use an external algorithm, like SHA-512 to compute checksums. Mathias Hoys suggested something similar, but I usually prefer Perl and Digest::SHA module for that, for the reasons of computational efficiency. Perl is using C-language routines, while I suspect that DBMS_CRYPTO uses PL/SQL to compute the hashes.
-- http://mgogala.byethost5.comReceived on Wed Mar 06 2013 - 13:46:19 CET