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

From: Mark D Powell <mark.powell_at_eds.com>
Date: 28 Nov 2001 12:46:41 -0800
Message-ID: <178d2795.0111281246.1ca41586_at_posting.google.com>


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?

Perhaps part of what you are seeing is due to the fact that for packaged procedures and functions the dependency is from the package level to the object (table, view). Also only the package and package body and not the packaged function/procedure appear in dba_objects. The other problem you may run into is that packaged code can be wrapped so that you can not see the text source in dba_source.

I hope this helps you determine what you are looking at, and what else you need to do.

  • Mark D Powell --
Received on Wed Nov 28 2001 - 21:46:41 CET

Original text of this message