Toad's optional Debugger module provides you with the functionality to easily debug PL/SQL procedures, functions, and triggers. In addition, you can debug SQL scripts using Script debugging, and Java using Java debugging.

To use the Debugger

Note: If you are debugging on a RAC instance, see the Debugging on a RAC tips.

  1. Enter code into the Editor.

  2. From the Debug menu, select the debugger you want to use (DBMS, JDWP, or Script)

  3. Make sure the debug button is depressed and then compile your code with debug information by clicking Compile Code button.

  4. Set Breakpoints and Watches.

  5. Click the lightning bolt to execute code. Execution will stop if it encounters a breakpoint.

You can execute code slowly by using the following instead:

To end a debugging session while you are stepping through code

 

Related Information