Re: function/procedure dependencies
Date: Mon, 24 Apr 2006 20:26:36 +0200
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?
[Quoted] CONNECT BY PRIOR object_id = referenced_object_id START WITH referenced_object_id =
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