Navicat Oracle Debugger can help you with the testing and debugging of SQL functions, procedures, queries, etc. To start debugging, open the design form of a function and set the breakpoints. Then, click the Debug button in the toolbar. A parameter box will pop up if your function or procedure requires you to input parameters. This is the default layout of the debugger. Once the debugger reaches a breakpoint it will stop the program execution and highlight the line where a breakpoint was reached in the Code pane. There are several useful views to help breakdown the information. The “Breakpoints” view will display all of the breakpoints at the bottom screen. The “Call Stack” view will display the function or procedure calls of the current line. The “Watch List” view will display information about the variables being watched. And finally, the “Smart Data” view will display information about the variables associated with the breakpoints. You can control the debugger using the Run, Step Over, Step In, Step Out, Step End and Stop buttons. To add a variable to the Watch List, simply right-click the highlighted code and choose “Add to Watch List.” The other tabs show the message log and the output of the function or procedure.
