script to list all procedures called by plsql code

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 Received on Mon Aug 25 2003 - 07:38:19 CDT