Re: incomplete dependency data

From: JLParke <jeffersonparke_at_hotmail.com>
Date: 24 Mar 2004 06:34:52 -0800
Message-ID: <ebdfae8.0403240634.441b542c@posting.google.com>

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<40606a06$0$290$626a14ce_at_news.free.fr>...
> "JLParke" <jeffersonparke_at_hotmail.com> a écrit dans le message de
> news:ebdfae8.0403230839.6f571f66_at_posting.google.com...
> > 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 - 08:34:52 CST