Re: function/procedure dependencies

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

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...