Request the “DEBUG ANY PROCEDURE” privilege from your DBAs. This allows full interactive debugging of stored procs and functions in SQL Developer (probably Toad as well).
In Tools/Preferences/Debugger, set ‘Prompt for Debugger…’ (use own ip address when prompted)
Open the body of a package to add a breakpoint
Then compile for debug
Right click somewhere in the package and click debug
Doesn’t work from an external app (have to run the proc from inside sql developer)