Installation
System Requirements
Install Toad
Specify App Data Directory Location
Read-Only Installation
Install Toad Silently
Install Toad on Citrix Systems
Upgrade Toad
Upgrade Automation Scripts
Files Migrated During Upgrades
Uninstall Toad
Create Connections
Understand Toad Connections
Create Access Connections
Create Amazon Redshift Connections
Create BusinessObjects Connections
Configure DB2 Client Connections
Configure DB2 LDAP Support
Create DB2 Connections
Create Excel Connections
Create Google Analytics Connections
Create Hive Connections
Create Intelligence Central Connections
Create MySQL Connections
Create ODBC Connections
Configure Oracle LDAP Support
Create Oracle Connections
Create Oracle BI Connections
Create PostgreSQL ODBC Connections
Create Salesforce Connections
Create Snowflake Connections
Create SQL Server Connections
Create SSAS Connections
Create SAP Connections
Create SAP HANA Connection
Create Teradata Connections
Troubleshoot Connections
Troubleshoot Access Issues
Troubleshoot DB2 LUW Issues
Troubleshoot DB2 z/OS Issues
Troubleshoot Informix Issues
Troubleshoot MySQL Issues
Troubleshoot Oracle Issues
Troubleshoot SQL Server Issues
Configure Version Control
About Debugging SQL
Use the Debugger to debug any script that contains a procedure regardless of the SQL included in the script (i.e., SELECT statements).
Note: You cannot debug CLR stored procedures.
To debug SQL
- See Set Up Debugging for more information..
- Right-click a procedure in the Object Explorer and select Debug.
-
Set start parameters.
Tip: You can manually set start parameters at anytime by clicking
in the Debug toolbar.
Configure Debugger Options
|
To... |
Use this Option Page... |
|
Set an option so function calls are not evaluated when hovering the cursor over watches |
Debugger | General |
|
Select a default desktop configuration that displays when starting or ending a debugging session |
Tips:
-
If you have not set a breakpoint, clicking
runs the SQL script to completion without stopping.
- If you try to run a debug script, you are prompted to set start parameters to use as an entry point, as well as provide values for any required parameters.