Re: function/procedure dependencies
Date: 24 Apr 2006 12:14:03 -0800
Frank van Bortel (frank.van.bortel_at_gmail.com) wrote:
: Malcolm Dew-Jones wrote:
: > Frank van Bortel (frank.van.bortel_at_gmail.com) wrote:
: > : Frank Dietrich wrote:
: > : >
: > : > For standalone functions and procedure I can use the information from the
: > : > *_DEPENDENCIES tables. But I need this information for functions and
: > : > precedures inside of packages. So the package dependencies alone provide
: > : > not enough information.
: > : >
: > : Does 'connect by' ring a bell? It should...
: > and your point is?
: select object_id
: from public_dependency
: CONNECT BY PRIOR object_id = referenced_object_id
: START WITH referenced_object_id =
: (select object_id
: from dba_objects
: where owner = '&which_owner'
: and object_name = '&object_name'
: and object_type = '&object_type')
: Take it from there
On my system that doesn't appear to show the dependencies of functions and procedures within a package, only the dependencies of the whole package to other objects that are not in the package. Received on Mon Apr 24 2006 - 22:14:03 CEST