That is not really an answer
Steef D., July 08, 2019 - 9:16 pm UTC
The question was how to debug all those procedures the best way, so what are the best tools for debugging, not for logging.
July 11, 2019 - 2:56 pm UTC
Adding instrumentation - logging - is a great way to debug your code. Provided you capture all the relevant information, you can walk back through the log to see what happened.
A reader, July 09, 2019 - 8:46 am UTC
Use third party tool PLSQL Developer and SQL Developer ( Oracle) and Toad for Oracle.
on Debugging from SQL Developer
Rajeshwaran Jeyabal, July 10, 2019 - 7:33 am UTC
July 11, 2019 - 2:52 pm UTC
Thanks for sharing these.
May be you are looking for...
Imran, July 18, 2019 - 6:48 am UTC
You may use DBMS Profiler which not only gives you info on the flow of code but also stats on each procedure/function and line of code , no. of times a line is executed and time taken. Based on these stats you may take decision n change code appropriately.
More info on how to configure and run this utility can be found at
http://www.dba-oracle.com/t_dbms_profiler.htm