Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: function/procedure dependencies

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@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
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 - 13:26:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US