Basic Debugging
Toad contains a full-featured symbolic debugger. Toad also enables script debugging using these same debugging techniques. This section covers PL/SQL debugging.
You can debug PL/SQL code while it is executing, change variables on the fly, see the contents of variables and cursors, and stop the execution of code at predetermined points (after so many loops or even after a variable contains a certain value).
Placing the cursor on a line in the code and clicking Run to Cursor will stop the execution of the code when the line with the cursor on it is reached.
Tip
I use the Trace Into (F7 keyboard shortcut) as a next step button. After I get to the section of code I want to monitor closely, I use this button to walk through the code ...
Get Toad for Oracle Unleashed 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.
