SQL Debugger - Oracle Debugger

The new Oracle SQL Debugger has been designed to help with testing and debugging of SQL functions and procedures for Oracle. Its debugging features include:

• Setting break points in the function or procedure body. A user can set a break point at any line in the function or procedure source code in order to run it up to this line. The breakpoints can be viewed in the Breakpoints tab.
• Settings procedure parameter values in the beginning of execution. The parameters can be set to null, default or a value chosen by a user.
• Running the function or procedure up to next break point. The execution can be stopped at any time using the stop button. Ouput messages for the execution can be viewed in the Console tab.
• "Step Over" button allows the user to move to the next line of the code.
• The user can view variables and their values during the execution in the Variables tab.
• The user can enter variables from the Variables tab to the Watches tab, watch their values and change values of the variables that are not parameters.
• The user can open a separate Query Window as Target Query Window and run queries before the debugging starts.
• The user can open a separate Query window as Debugger Query Window and run queries while debugging a procedure, when it's paused.