Re: incomplete dependency data

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 24 Mar 2004 20:17:01 -0800
Message-ID: <3722db.0403242017.532f3197@posting.google.com>

As discussed in a recent thread, a dependency is always between an object and the WHOLE package, and never between the object and a specific component of the package (procedure, function, ...).

Daniel

> > > Can anyone explain how the data returned by the SYS.ALL_DEPENDENCIES
> > > and SYS.DBA_DEPENDENCIES views can be incomplete? Both are missing
> > > dependencies related to atleast one stored procedure.
> > >
> > > Thanks,
> > > JLParke
> >
> > Version? Example listing?
> >
> > Michel Cadot
>
> I found out that packaged procedures and functions are not first-class
> objects like their unpackaged cousins and so are not included in
> object and dependency system tables. These packaged routines were the
> ones that were missing from the dependency data. Thanks.
>
> JLParke
Received on Wed Mar 24 2004 - 22:17:01 CST