Re: Dependencies between Packaged Procedures

On 12 Mar 2004 02:26:34 -0800, learning_still_at_hotmail.com (Newbie) wrote:

>How can we list dependencies between packaged procedures? We have all
>the procedures clubbed within one package or another.
>USER_DEPENDENCIES shows dependencies between packages but NOT between
>procedures. Is there any script/resource that can list out all the
>procedures, in whatever package they are, which are called from or
>depend on any given procedure?
>
>Thnx.

Hi Newbie,

No. A package specification or a package body is one compilation unit. If, for instance, an object referenced from within a package body is invalidated, the whole package becomes invalidated.

• Kenneth Koenraadt