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

Home -> Community -> Usenet -> c.d.o.misc -> Re: PLSQL debugging

Re: PLSQL debugging

From: RichardGrant <RichardGrant_at_Capgemini.co.uk>
Date: Fri, 19 Feb 1999 17:55:58 +0000
Message-ID: <36CDA5AE.1903@Capgemini.co.uk>


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

Original text of this message

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