Re: script to list all procedures called by plsql code

Saeed wrote:

> Hi,
>
> I'm looking for a perl/shell/sql script that will analyse a piece of
> pl/sql (package procedure etc) and produce a list of all the procedures
> and functions it calls.
>
> I know dba_dependencies does a sterling job but that is only at package
> level - often times I want a quick list of procedures called within the
> same package.
>
> So if I have a procedure pk1.proc1 that calls pk1.proc2 and pk2.proc1,
> dba_dependencies would just list proc2, but I would like to see:
>
> pk1.proc1
> pk1.proc2
> pk2.proc1
>
> Obviously, dynamic sql throws a spanner in the works, but we'll deal
> with that some other time.
>
> I've thought of writing a perl script to do this, but perhaps someone
> has already done it.
>
> Kind regards,
>
> Saeed
>
> sr_ng 786

If on 9i this might get you closer to a solution SQL> DESC <PACKAGE_NAME>

HTH & YMMV HAND! Received on Fri Aug 29 2003 - 19:03:14 CDT