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: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 24 Apr 2006 12:14:03 -0800
Message-ID: <444d237b$1@news.victoria.tc.ca>


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 - 15:14:03 CDT

Original text of this message

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