Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: on wich line is the procedure error

Re: on wich line is the procedure error

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/17
Message-ID: <955988044.16773.0.pluto.d4ee154e@news.demon.nl>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US