Re: What is debugging tool for PL/SQL?
From: Ken Mills <mills_at_cpcuiia.org>
Date: 1996/12/06
Message-ID: <01bbe37c$a677a790$78e461c7_at_Mills>#1/1
Date: 1996/12/06
Message-ID: <01bbe37c$a677a790$78e461c7_at_Mills>#1/1
In SQLPlus, type show error. This will show the errors by line number.
Then list the package.
To debug your program, include dbms_output.put_line calls in your pl/sql
code. Don't forget to SET SERVEROUTPUT ON.
-- Ken Mills West Chester, PA. kenm_at_ccil.org mills_at_cpcuiia.org Bobby Vukovic <bobbyv_at_ussinc.com> wrote in article <32A5F190.4DDB_at_ussinc.com>...Received on Fri Dec 06 1996 - 00:00:00 CET
> 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?
>
> Thanks a lot.
>
> Bobby
>