Skip to Main Content
Toad for Oracle Unleashed
book

Toad for Oracle Unleashed

by Bert Scalzo, Dan Hotka
July 2015
Intermediate to advanced content levelIntermediate to advanced
288 pages
7h 26m
English
Sams
Content preview from Toad for Oracle Unleashed

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Toad for Oracle

Toad for Oracle

Dan Hotka
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern
Oracle in a Nutshell

Oracle in a Nutshell

Rick Greenwald, David C. Kreines

Publisher Resources

ISBN: 9780134131900Purchase book