Re: Detecting executed PL/SQL procedure

From: Cliff Dabrowski <cliffd.ng>
Date: Fri, 4 Jan 2002 17:00:42 -0500
Message-ID: <3c362699$1@172.22.1.229>

Anamika,

This can be done by using the trace facilities of Oracle but can be rather daunting and difficult to pinpoint the actual caller of he procedure. I have a much easier solution that I can suggest (a product) so please feel free to email me for more detailed information and/or take a look at http://www.compuware.com/products/numega/dbpartner/index.htm

Hth,

~Cliff

"Anamika" <anamika_at_home.com> wrote in message news:Xns918C6A29FC07Ehemaniryahoocom_at_207.181.101.12...
> Hi,
> I have Oracle 8.0.5 database with lots of third party PL/SQL procedures
> installed. I also have applications that invoke these PL/SQL procs.
> Recently encountered problems with these PL/SQL procs and I need to find
> out which one of them is being executed. i.e., when a function is called
> in the application, it eventually makes a db connection and executes a
> PL/SQL procedure. Is there a way to find out which PL/SQL procedure is
> executed ? There is no documentation with the application which explains
> this.
>
> Thanks,
> -A
Received on Fri Jan 04 2002 - 16:00:42 CST