Re: Inter-Dependencies of PL/SQL procedures and functions

Hi Matthias,

I am not sure to have understood exactly what you want. But the script in $ORACLE_HOME/rdbms/admin/ultdtree.sql may help you. It builds a temporary table, insert dependency relations into it and show them in a hierarchical fashion.
It shows only package dependecies, though (I am in Oracle 7.3.3). I don't know if Oracle8 has improved it... At least in 7.3.3, you would need to build a parser and work on your code...

Hope this helps and,
please, let me know if you find something better.

Regards,
Maurício.

In article <37CFD4B5.5ECCD088_at_ubs.com>,   matthias.graf_at_ubs.com wrote:
> Hi all
>
> is there a tool that can report which procedures/functions are
> referenced by respectivley calling other procedures/functions as
several
> procedures/functions remain within the same package.
>
> Thanks for a tips and hints
> Matthias Graf
> matthias.graf_at_ubs.com
>

--
Maurício B. Falleiros <mbf_at_uniconsult.com.br>
Uniconsult Sistemas e Serviços


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.