SQL Debugging
Go Up to Session 9: SQL Debugging and Profiling
The SQL Debugger is another database productivity tool that lets you debug SQL Server, Oracle, Sybase ASE or DB2 stored procedures, as well as Oracle functions. SQL Debugger simplifies the task of finding coding errors.
- In the Navigator, expand the Procedure or Function node.
- Right-click the object and select Debug from the context menu.
- If the procedure or function takes input parameters, the Procedure Execution window prompts you to enter values.
- Enter input values and press Continue.
- Tip: Rapid SQL allows the user to save the input variable values to a file for later use. This is very helpful for procedures/functions with many input variables that need to be run repeatedly.
- The application opens the SQL Debugger Interface.
The Debugger features basic execution, line-by-line execution, breakpoint support, and other common debugging features. For details, refer to the relevant online Help topics.
Proceed to SQL Profiling- Oracle Only.