Re: How to debug the PL/SQL block?

From: Hans-Friedrich Pfeiffer <Pfeiffer.Hans-Friedrich_at_t-online.de>
Date: Thu, 24 Dec 1998 23:33:48 +0100
Message-ID: <3682C14C.2B9@t-online.de>

Huang Weidong wrote:
>
> I am new to oracle. Is it possible to debug the PL/SQL block in
> SQLPLUS? Or I need to use other tools to debug the block? And how?
>
> Thank in advance.
>
> weidong

Hi Huang Weidong,

you could debug your PL/SQL-Code with Oracle-Procedure-Builder ( only availabe under Windows ... ).
If you use Oracle 7.3 or later you could debug your code by inserting write-commands to your server-disks. Don't know the name of the package you must run before. But really, the best way is to use the pricedure builder.

Greetings

Hans Received on Thu Dec 24 1998 - 16:33:48 CST