steph0h wrote:One possiblity is to do this yourself using conditional compilation (depending on your version of Oracle). You can conditionally compile in lines using dbms_output.put_line (or however else you want to do it) marking when a procedure is entered. A lot of work but functional.
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?
Then you will have information about every procedure calls (except for a dynamic execution) in the dba_identifiers view. All you have to do is to write proper select ;)
ALTER SESSION SET PLSCOPE_SETTINGS='IDENTIFIERS:ALL';