Re: Tracking/monitoring a PL/SQL procedure

Hi,
  Since program execution returns to java from oracle only after the procedure executes, i dout if you can rely on a v$...   A good idea may to be set a gloabl variable in proedure/package from the java call and capture the global variable before closing the connection to the database. Alternatively you cout have a OUT parameter that passes out the procedure name.

ET

hemanir_at_yahoo.com (Anamika) wrote in message news:<5130f039.0201160543.29c39fc0_at_posting.google.com>...
> Hi,
> 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 Fri Jan 18 2002 - 01:45:21 CST