Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PLSQL debugging
Dr. Jan Dieckmann wrote:
>
> Try Hora 3, http://www.keeptool.com.
> regards Jan
>
> Sam Jordan wrote:
>
> > Hi
> >
> > I'm experimenting with PLSQL and stored procedures. But whenever
> > there is an error in my script with 'create procedure' and
> > 'create package' statements, I only get the message
> > 'Package/Procedure created with compilation errors' when running
> > the script in sqlplus. This doesn't help much... I'd like to know
> > where the error happens and I'd like to see a more detailed error
> > message. Ideas?
> >
> > bye
> > --
> > Sam Jordan
Type sho err at the SQL prompt & you should get some explanation as to the line number of the error. Received on Fri Feb 19 1999 - 11:55:58 CST
![]() |
![]() |