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

You may want to download the free version of Toad software. It's a GUI software developed for Oracle databases. It will show you all of the database objects and show you their dependencies.

You can download it at www.toadsoft.com

• Ricky

"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?
>
>
>
Received on Mon Jan 07 2002 - 07:42:11 CST