| Embarcadero® SQL Debugger™ |
Quickly identify errors and potential bottlenecks in SQL
 
Embarcadero SQL Debugger helps quickly identify errors by stepping through code as it executes. In addition, the profiling option displays the expense of each line of code indicating potential bottlenecks. SQL Debugger is available as an optional module for Embarcadero DBArtisan or Rapid SQL. Embarcadero SQL Debugger removes the guesswork from troubleshooting database logic errors. You can determine whether or not your database logic functions properly by stepping through the execution of code to pinpoint the source of any errors. By using SQL Debugger, you'll be better equipped to fix bugs in minutes instead of hours and to deliver higher quality applications. SQL Debugger offers:
Isolate and correct faulty database logic that could lead to expensive application downtime Creating optimized and accurate database code fast and efficiently is the goal of every developer. When you are working with large amounts of code, isolating and fixing a bug can be like finding a needle in a haystack. Embarcadero SQL Debugger removes the guesswork from troubleshooting database code logic errors and inefficiencies. Embarcadero SQL Debugger allows you to step through code as it executes, enabling you to watch database logic and quickly identify the source of errors. As an added bonus, you can set a code profiling option that displays the expense of each line of code as it is executed, indicating potential performance bottlenecks in the current body of work. And, because Embarcadero SQL Debugger provides a common user interface for all major DBMS platforms, businesses can lower costs and boost productivity by standardizing on a single database administration solution. The Embarcadero SQL Debugger is available as a licensed add-on within DBArtisan and Rapid SQL Pro. Debug Procedures, Triggers, Functions*, Packages* and Adhoc SQL Scripts Launching a debugging session is as easy as selecting a procedure, function, package or trigger, and right-clicking the mouse to select “Debug” from a context menu. The Embarcadero SQL Debugger automatically determines the number, type and name of any input parameters and presents a sizable dialog, and prompts you for each input variable value before beginning the debug session. If a procedure or function takes records or types as parameters, the application automatically generates an anonymous block for debugging purposes. Step Through Code One Line at a Time The Embarcadero SQL Debugger uses several navigational functions to interactively “walk” programmers through code as it executes on the database. You can “step into” nested stored procedures to unlimited levels, as well “step out of” child objects, resuming line-by-line, step debugging in the parent object. During a debugging session, programmers can set one or more breakpoints in the currently executing code or in any stored object in the program call stack. Breakpoints can be temporarily disabled or enabled without having to add or remove them. To make you more productive, the Embarcadero SQL Debugger remembers all breakpoints in the program and any nested programs from one debugging session to the next. The Embarcadero SQL Debugger also offers a profiling option that details how long each line of code - SQL or procedural - takes to execute (in milliseconds). In addition, the Embarcadero SQL Debugger allows you to view output* and temp table data** throughout the debugging session. Capabilities include:
Watch Variables, Call Stacks and Dependencies After a debug session is initialized, programmers are presented with four debug view windows at the bottom of the screen under the source code: Watch, Variables, Call Stack and Dependency Tree.
DBMS SupportEmbarcadero SQL Debugger supports the following DBMS versions running on both UNIX ® and Windows NT ®-based servers.
System Requirements
|