Tracking/monitoring a PL/SQL procedure
From: Anamika <hemanir_at_yahoo.com>
Date: 16 Jan 2002 05:43:05 -0800
Message-ID: <5130f039.0201160543.29c39fc0_at_posting.google.com>
Hi,
[Quoted] [Quoted] I have a Java program calling a PL/SQL procedure in the Oracle DB. Dont know the name of the pl/sql procedure that the java program calls.
Is there a way to find out which pl/sql procedure is executed when the java program executes ? Tried v$ tables not very successful. Maybe missing something.
Or can I set a trigger or something else, that will kick in when the pl/sql proc executes ?
Date: 16 Jan 2002 05:43:05 -0800
Message-ID: <5130f039.0201160543.29c39fc0_at_posting.google.com>
Hi,
[Quoted] [Quoted] I have a Java program calling a PL/SQL procedure in the Oracle DB. Dont know the name of the pl/sql procedure that the java program calls.
Is there a way to find out which pl/sql procedure is executed when the java program executes ? Tried v$ tables not very successful. Maybe missing something.
Or can I set a trigger or something else, that will kick in when the pl/sql proc executes ?
Thanks,
-A
Received on Wed Jan 16 2002 - 14:43:05 CET