Re: What is debugging tool for PL/SQL?

From: <jhostetter_at_dande.com>
Date: 1996/12/09
Message-ID: <58hfcm$3il_at_lily.redrose.net>#1/1

In article <01bbe37c$a677a790$78e461c7_at_Mills>,

   "Ken Mills" <mills_at_cpcuiia.org> wrote:
>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.

The Procedure Builder tool from Oracle is a nice GUI tool that allows you to do line-by-line debugging.

---

Jay Hostetter
Database Administrator
D. and E. Communications
Ephrata, Pa. U.S.A
jhostetter_at_dande.com

---

Received on Mon Dec 09 1996 - 00:00:00 CET