The Script Debugger is an extension to the Editor that you can use to debug short scripts. Using the Script Debugger, you can do the following in addition to standard Editor functions:
Note: Standard source control fully integrates with the Script Debugger. However, you cannot use Team Coding with the Script Debugger.
To use the Script debugger
From the View | Toad Options window, select Debug | Script Debugger.
To commit changes
Click on the main toolbar. This will commit changes in both sessions.
After you run a script, Toad displays the output and maintains a running list of system variables and user variables. This lets you keep track of what has been set.
Use the toolbar buttons to copy or print the output, and to save the output to a file or Excel spreadsheet.
Displays any output from the script you are running, such as errors, status of system variables, and data in output format.
|Errors||Displays errors. Click an error to go to the location in the script where the error occurred. Double-click an error to jump to possible solutions.|
|Grids||Display the data selected by the script. One grid displays for every select statement.|
Displays output for all the scripts run during this session, or until the history tab is cleared. This tab is hidden by default, but can be turned on in the options.
See Execute and Compile Options in the online help for more information.
|Environment||Displays user, system, and bound variables and their values for the script.|
Toad provides an intuitive and efficient way to write, run, and test your SQL and PL/SQL code. Toad supports efficient code management for a single developer or a whole team of developers.
Breakpoints are markers in your code where you want to stop execution during debugging. The breakpoints window displays as a tab in the desktop panel beneath the main Editor window. If you cannot see the Breakpoints tab, you may need to add it to your desktop.
From the Breakpoints window, you can easily work with your breakpoints. You can select from the toolbars on the window itself, or you can use the right-click menu to access more functions.
To add the breakpoints tab to your desktop
Right click in the desktops area and select Desktop Panels | Breakpoints. The breakpoints tab displays.
To open the breakpoints window
In the desktop area, click the Breakpoints tab.
See the online help for more information about using Breakpoints.