Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP, PL/SQL: Determination of Functions & Procedures using SQL
The functions/procedures that I would like to find using SQL are
private,
they are not in the package but are in the package body
Salto
Salto wrote:
> (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 Wed Nov 28 2001 - 14:36:58 CST