Re: PL/SQl: is there any debug tool?

sl6gs_at_cc.usu.edu wrote:

> HI Everyone:
>
> I use PL/Sql to build lots
> of functions embeded in my SQL.
> But the problem I have is when
> I compile the PL/Sql function with
> error, a error message" function created
> wiht compiling error ' , But it will never
> tell me which line is wrong , like in Cand Pascal,
> is this the nature of PL/SQl, or there is a debug
> tool that missed?
>
> Any suggestion will be greatly appreciated.
>

Assuming you're in SQL*Plus:

   show errors

HTH, -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Chris Kasten
Programmer/Analyst (among others...)

#include <sys/std_disclaimer.h>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Fri Jan 26 1996 - 00:00:00 CET