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

From: Steve <smontgomerie_at_hotmail.com>
Date: 28 Nov 2001 12:38:25 -0800
Message-ID: <156709aa.0111281238.55eb1ebe@posting.google.com>

Someone else can probably elaborate better on this but are they 'wrapped'. The intent of wrapping being to encapsualte the code so that no-one can read it.

Steve

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 Wed Nov 28 2001 - 14:38:25 CST