Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> script to list all procedures called by plsql code

script to list all procedures called by plsql code

From: Saeed <sr_ng_at_goawaynms-sys-lts.demon.co.uk>
Date: Mon, 25 Aug 2003 13:38:19 +0100
Message-ID: <zZZslRB7MgS$EwT6@nms-sys-ltd.demon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US