Re: What is debugging tool for PL/SQL?

Bobby Vukovic <bobbyv_at_ussinc.com> wrote:

>When having hundreds of lines in a stored procedure
>it would be much better to be able to know at which line
>there are errors insted of only seeing message
>"Warning: PACKAGE BODY xyx created with compilation errors"
 

>Does anybody knows such a tool or procedure?

If you're using SQLPlus, try

        show error;
after the message. This will give you both line and column number.

Remember to spool the compilation output (or have a large enough buffer in SQLPlus) to be able to see the actual line.

Good luck.

alf Received on Thu Dec 05 1996 - 00:00:00 CET