How to Set Up SQL Debugging With SQL Developer

  • 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)
  • See this Remote Debugging How To for more details