DBMS_DEBUG - Generic Debugging
Team,
We are looking at developing a generic debugging package API which shall be present as a core package to be called for any kind of debugging across the product which has more than 500 procedures, Packages , triggers etc. We were exploring with DBMS_DEBUG package API given with the standard libraries, will it be good enough to meet the normal expectations of a debugging script or API which can be called inside other packages, secondly this DBMS_DEBUG has the capability to debug sessions remotely from other independent sessions.
Will this be right approach, or do we have more sophisticated package API's which can be put into proper usage, our debugging style would include, Debugging other sessions, Printing Variables of other sessions etc. My question can be a bit vague, but hope i have conveyed the intent of the question. Expect a good participation/discussion. Thanks in advance.