Navicat for Oracle Debugger can help you with the testing and debugging of SQL functions, procedures, queries, etc.
You can open the design form of a function to start the debugger.
Set the breakpoints to start debugging. Click “Save as Debug” button in the toolbar.
Click “Debug” button in the toolbar, a parameter box will pop up if your function or procedure requires you to input parameters.
Once the debugger reaches a breakpoint, it will stop the program execution and highlight the line where a breakpoint was reached in the Code Window (the red arrow).
You can use the buttons inside the red rectangle to control the debugger.
Useful views to help breakdown the information:
Call Stack (the blue rectangle) – displays the function or procedure calls of the current line.
Watch List (the green rectangle) – displays information about the variables being watched.
Smart Data (the purple rectangle) – displays information about the variables associated with the breakpoints.
Breakpoints (the green arrow) – displays all the breakpoints.
Log: shows the message log
DBMS: shows the output of the function or procedure.