Here are some tips for free server_side debugging tools:
- If you can live with all your messages appearing only at the end of
your program, DBMS_OUTPUT is useful.
- DBMS_APPLICATION_INFO.SET_MODULE is useful to put some debugging
messages in your code. You can then see where you are by spying on the
columns ACTION and MODULE of V$SESSION.
- DBMS_PROFILER collects some timing statictics on each (executable)
line of code. A useful report is also provided. DBMS_PROFILER has to
be installed (from rdbms/admin subdirectory), as well as the report
(from plsql/demo subdirectory, if I remember well).
- If you want to get even more details, use DBMS_DEBUG. I don't have
any experience with it, but it seems very powerful.
HTH
Daniel
Please advise what tools good for debugging PL/SQL:
a) commercial
b) free
I tried some of them but they not to good work with debugging inside
packages.
Any opinions welcome.