Re: Tools for debug PL/SQL

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 23 Jul 2003 08:49:28 -0700
Message-ID: <3722db.0307230749.3055488e_at_posting.google.com>


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.
Received on Wed Jul 23 2003 - 17:49:28 CEST

Original text of this message