A new version of Database Navigator plugin is available (3.0.1658)
The main achievement in this release is the Oracle PL/SQL debugger.
The debugger wraps the Oracle DBMS_DEBUG package, and supports most of the features a debugger should offer:
- setting and removing breakpoints before and during debug process
- breaking/resuming execution: step over, step into, step out, run to breakpoint, run to cursor
- viewing and changing variable values on suspended execution
It currently supports only local debugging, i.e. the execution of the debugged subject (method/script) must be triggered in, and is controlled by the plugin environment. JDWP debugging will be probably supported in the future.
Pending features: navigable execution stack, expression evaluation, script debugging
The debugger is still in experimental phase, so you may experience hanging sessions and program execution not breaking where expected.
Also note that you need certain privileges to run the debugger on a given database. You will be guided through the prerequisites on each debug run. You may need to ask your database administrator for certain debugging privileges.
Plugin builds are available for IntelliJ 8.1 as well as for 9.0 (IU and CE), for both JRE5 and 6. See plugin repository page for more details.
Please feel free to report any issues in the dedicated request tracker: