Re: function/procedure dependencies
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 24 Apr 2006 20:26:36 +0200
Message-ID: <e2j56h$97v$1_at_news5.zwoll1.ov.home.nl>
Date: Mon, 24 Apr 2006 20:26:36 +0200
Message-ID: <e2j56h$97v$1_at_news5.zwoll1.ov.home.nl>
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
[Quoted] 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...Received on Mon Apr 24 2006 - 20:26:36 CEST