"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<7RR3b.84936$kP.14870_at_fed1read03>...
> 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!
Did you read the question??
Received on Sun Aug 31 2003 - 19:33:07 CDT
