PL/SQL (MOSC)

MOSC Banner

DBMS_DEBUG - Generic Debugging

edited Jun 29, 2018 5:00AM in PL/SQL (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center