Re: Finding a PL/SQL error

>
> I'm not clear what your error condition is all about. The MOST frustrating
> thing I found when I first began using PLSQL is that the line numbers which
> were reported as errors had no relationship to the source file! That is, until
> I wrote a script to clean the source file of all lines BEFORE the first
> DECLARE and any BLANK lines. When I viewed the resultant file, the reported
> line number error matched directly to my source file.
>
> \lfeges

Try this:

  select text from user_source
  where name='<PROC_NAME>'
  and line between .. and ..;

Bye,

   Margot Received on Sun Jul 02 1995 - 00:00:00 CEST