FC2Video

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. The “Stacks” view will display the function or procedure calls of the current line. The “Data” view will display information about the variables associated with the breakpoints. And finally, the “Watches” view will display information about the variables being watched. 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 control-click the highlighted code and choose “Add to Watch List.” The bottom part of the debugger shows the log and the output of the function or procedure.