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.