Skip to Main Content
Toad Pocket Reference for Oracle, 2nd Edition
book

Toad Pocket Reference for Oracle, 2nd Edition

by Jeff Smith, Patrick McGrath, Bert Scalzo
May 2005
Intermediate to advanced content levelIntermediate to advanced
130 pages
4h 31m
English
O'Reilly Media, Inc.
Content preview from Toad Pocket Reference for Oracle, 2nd Edition
Debugger
|
71
Save proc parameters between sessions
Causes parameters used during execution to be saved
between sessions. The parameters are stored in your local
ToadParams.ini file for reuse the next time you execute
the same stored program.
Transaction Control
Provides Commit, Rollback, and Prompt choices. Select-
ing Commit or Rollback appends an Oracle COMMIT or
ROLLBACK statement to the anonymous block created
by the Toad Debugger for executing stored programs (see
the later section “Setting Parameters” for more details). If
you select Prompt (the default), Toad will ask if you
want to “Commit changes to debug session?” each time
you finish a debug session.
Default to “Compile with Debug”
If this option is checked (the default is unchecked), the
“Toggle compiling with Debug” button on the Toad
Standard toolbar will be in the on position when each
Procedure Editor session begins.
Show executable line indicators in gutter
Causes lines in your code that are eligible for break-
points to be highlighted with a blue dot in the gutter for
that line.
Debugger Menus and Toolbar
You can access Debugger functions from the Toad Debug
menu (available from the Toad Menu toolbar and shown in
Figure 14), the Debugger toolbar, or the Procedure Editor
Right Mouse Debug menu.
The options are slightly different in each case. The Toad
Debug menu (shown here) provides several additional execu-
tion options; you can select ...
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

Oracle PL/SQL Language Pocket Reference, 5th Edition

Oracle PL/SQL Language Pocket Reference, 5th Edition

Steven Feuerstein, Bill Pribyl, Chip Dawes
Oracle RMAN 11g Backup and Recovery

Oracle RMAN 11g Backup and Recovery

Robert Freeman, Matthew Hart
Oracle Database 11g A Beginner's Guide

Oracle Database 11g A Beginner's Guide

Ian Abramson, Michael Abbey, Michael Corey

Publisher Resources

ISBN: 9780596529079