How to see the hierarchy of calls in a procedure

[Cl]

Hi.
I

 

[Claus Pedersen]

A little short for my liking

But try to look into documentation about the view USER_IDENTIFIERS.

The data is generated by using the setting
ALTER SESSION SET PLSCOPE_SETTINGS='IDENTIFIERS:ALL'

and do a compilation of all PL/SQL code.

 

[Worker]

Or maybe you're looking for DBMS_UTILITY.format_call_stack or UTL_CALL_STACK.