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 a break point 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.
- Running the function or procedure up to the break point with parameters provided by the user. The execution can be stopped at any time using the stop button. Output messages for
the execution can be viewed in the Console tab.
- "Step Into" button allows to enter function calls in the body of the function or procedure.
- "Step Over" button allows to move to the next line of the code.
- "Step Return" button allows to execute the fucntion or procedure until the current operation returns and then to exit. The results of the execution will be displayed
in a results view window.
- The user can enter variables and view their values during the execution in the Variables tab.
- The user can enter expressions and watch their values in the Watches tab.
|
