Re: is there a dictionary query that is able to tell which public procedure calls a particolar line of code?
From: ddf <oratune_at_msn.com>
Date: Wed, 16 Sep 2009 05:18:17 -0700 (PDT)
Message-ID: <696f9efc-2d3d-4503-a4aa-405b8b08361d_at_f10g2000vbf.googlegroups.com>
On Sep 16, 3:28 am, yossarian <yossaria..._at_operamail.com> wrote:
> Good morning, Oracle 10.2.0.3 SE on Linux here.
>
> I'm trying to understand an Oracle package horribly written by an
> ex-coworker.
>
> Is there a dictionary query that is able to tell which *public*
> procedure (i.e. included in package specification) calls a particolar
> line of code?
>
> I'm getting lost with bad indentation and sub-sub-sub-procedures...
>
> Thank you.
>
> Kind regards,
>
> Yossarian
Date: Wed, 16 Sep 2009 05:18:17 -0700 (PDT)
Message-ID: <696f9efc-2d3d-4503-a4aa-405b8b08361d_at_f10g2000vbf.googlegroups.com>
On Sep 16, 3:28 am, yossarian <yossaria..._at_operamail.com> wrote:
> Good morning, Oracle 10.2.0.3 SE on Linux here.
>
> I'm trying to understand an Oracle package horribly written by an
> ex-coworker.
>
> Is there a dictionary query that is able to tell which *public*
> procedure (i.e. included in package specification) calls a particolar
> line of code?
>
> I'm getting lost with bad indentation and sub-sub-sub-procedures...
>
> Thank you.
>
> Kind regards,
>
> Yossarian
You might try installing this:
http://asktom.oracle.com/tkyte/who_called_me/who.sql
It will report who called a given procedure, function or package but it won't tell you which line was called.
David Fitzjarrell Received on Wed Sep 16 2009 - 07:18:17 CDT