Chat now with support
Chat with Support

Toad for Oracle 17.1 - Getting Started Guide

Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Debug Scripts

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.

 

Script Debugger Overview

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:

  • Set Breakpoints
  • Run to Cursor
  • Step Over
  • Trace Into
  • Halt Execution

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

  • Select Debug | Script Debugger.
  • Or select View | Toad Options | Debugger | General and then select Script in the Debugger section.

To commit changes

Click on the main toolbar. This will commit changes in both sessions.

 

View Script Output

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.

Tab Description
Output

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

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.

 

Set Breakpoints

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.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating