Re: on wich line is the procedure error

either use
show errors
or
select * from user_errors where name = '<Your procedure>'

Hth,

Sybrand Bakker, Oracle DBA

J. Park <johan_park_at_hotmail.com> schreef in berichtnieuws 8dfb3r$k37$1_at_tesla.a2000.nl...
> When you create a procedure and you get an error,
> Oracle says: Warning: procedure created with compilation errors
>
> But it doesn't say on which line the error is.
> Is it possible to show the line with the error ?
>
> thanks in advance,
> Johan
>
>
Received on Mon Apr 17 2000 - 00:00:00 CDT