Using the PL/SQL Debugger
TOAD has an optional symbolic debugger, a procedure that allows you to watch the execution of the code, set variables on the fly, see contents of variables, and set break points and conditions (when the debugger is to start). The debugger is toggled on or off in the Procedure Edit window by pressing the icon that looks like a bug or by accessing the Debug option on the menu bar (see Figure 16.14). The debugger lets you step through the code as it executes line-by-line. You can add and delete breakpoints (using the Debug menu item or key strokes Ctrl+Alt+B and even set conditional breakpoints. You can also check for dependencies and loops.
Figure 16.14. TOAD Debug options.
The PL/SQL Debugger has numerous options, including ...
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
