SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Display Pl/SQL Call Hierarchy?

steph0hFeb 7 2013 — edited Feb 8 2013

Hello,

In my current project there exist lots of pl/sql functions and procedures which are all interconnected (and often without comments) and it's quite hard to step through the sourcecode to find out what's happening - I often end up having 5 or more packages open in SQL Developer switching endlessly from one window to the next just to figure out the execution chain. Who's calling who?

So I'm looking for some sophisticated tool to display the hierarchy of pl/sql functions and procedures. Ideally I want to be able to browse the whole function tree in any direction and display the source-code of a function without having to enter the package body. Is there anything out there that is at least partially fulfilling my hopes?

Thanks,
Stephan

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2013

Added on Feb 7 2013

#plsql

5 comments

1,910 views