Re: Dependencies between Packaged Procedures

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 12 Mar 2004 10:39:57 -0800
Message-ID: <3722db.0403121039.7f70e456@posting.google.com>

> 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.

I looked around, and can't find anything about which actual package procedures are referenced. My suspicion is that you're out of luck, as Oracle doesn't need to know this info (since the objects consistency is based on either the package or the whole package body, but never a specific package procedure). Can you explain to us why you need this info, and maybe we'll be able to give another solution?

Daniel Received on Fri Mar 12 2004 - 12:39:57 CST