Re: HELP, PL/SQL: Determination of Functions & Procedures using SQL

"Salto" <Salto_at_uswest.net> wrote in message news:3C04E717.FDF02DE_at_uswest.net...
> (Cross posts)
>
> I have a requirement to determine the functions, procedures
> and their dependencies
> in a large number of PL/SQL packages.
>
> Queries to the tables: all_objects, all_arguments and
> all_dependencies returns most of this information.
>
> The problem is that many functions and procedures that I can
> see reading the text
> returned from all_source is not in the tables listed above.
> I have tried the dba and
> user tables also without any additional information being
> returned.
>
> I cannot use all_source since I do not want to wade through
> all of this stuff.
>
> Does anyone know why I cannot see all of the
> functions,packages and dependencies
> in a PL/SQL package body using the oracle tables?

Not quite the answer to your question specifically, but for documenting this stuff I found Hora, found at http://www.keeptool.com, very useful. It can generate HTML documentation of your database objects by schema.

-Matt Received on Thu Nov 29 2001 - 04:05:04 CET