Client/Server Software Benelux
Tel: +31 23 542 22 27

Embarcadero SQL Debugger

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.

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.

*Oracle only

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.

* - All platforms
** - Sybase only

Capabilities include:

• Step Into: which executes the current instruction. If the instruction makes a call to a stored object, the application steps inside the nested child object.
• Step Out: which executes the remainder of the dependent child object and resumes line-by-line, step-debugging in the parent object.
• Step Over: which executes the current instruction without stepping into a nested child object if the instruction makes a call to a dependent object.
• Run to Cursor: which executes all instructions between the pointer and the cursor and then stops.
• Go: which executes all instructions and stops only upon program completion or when encountering a breakpoint.
• Breakpoint: which enables or disables a breakpoint at the current instruction line. Breakpoints can be set with no condition, a conditional expression or a skip count (stop after the breakpoint is skipped a certain number of times).

Watch Variables, Call Stacks and Dependencies