189 days ago,
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.