PL/SQL Debugger

The SQL Navigator development environment includes an integrated PL/SQL Debugger. The debugger requires a separate license agreement.

SQL Navigator’s Debugger helps you debug stored programs, including

$image\Sqln0004.gif$ procedures

$image\Sqln0004.gif$ functions

$image\Sqln0004.gif$ packages and package bodies

$image\Sqln0004.gif$ triggers

With the PL/SQL Debugger, you can:

$image\Sqln0004.gif$ Initiate debugging from within an editing session

$image\Sqln0004.gif$ Set watches and breakpoints before or during debugging directly from the code editor.

$image\Sqln0004.gif$ Execute any PL/SQL code step-by-step or point-to-point

$image\Sqln0004.gif$ Trace into multiple levels of procedure calls

$image\Sqln0004.gif$ Examine and set variables during execution of procedures.

$image\Sqln0004.gif$ View the call stack and values of watched variables at any point during the debugging session.

$image\Sqln0004.gif$ Access all functions of SQL Navigator after a debug session is started.

$image\Sqln0004.gif$ Debug PL/SQL code that is run from an external client-server application using SQL Navigator’s Just-In-Time Debugging feature.

$image\Sqln0004.gif$ Track your application’s flow of execution, monitor variables and even change the execution logic "on the fly" by modifying values of program variables.

Debugger commands

$image\Sqln0125.gif$