Re: Oracle Error Messages

Also, I'd recommend getting a PL/SQL development editor, such as SQL*Navigator (Quest) or SQL-Station (Platinum); they'll point you right to the offending line. Well worth the money.

Glen

"Glen E. Siferd" <gesiferd_at_go.com> wrote in message news:9aifkt$cga$1_at_news.doit.wisc.edu...
> How about this?:
>
> http://www.oraxcel.com/projects/sqlcodes/index.htm
>
> Glen
>
> <dennishancy_at_eaton.com> wrote in message
> news:9aidcl$42o$1_at_news.netmar.com...
> > Can anyone suggest a source that explains Oracle error messages AND has
> > hints
> > as to what I might check in my SQL to resolve the problem?
> >
> > In the past, I have received messages like ORA-01861, but the brief
 message
> > it
> > provides does not give much information. It takes me hours.. days.. to
> > determine where the problem is.
> >
> > The message I received today is
> >
> > ORA-01858: a non-numeric character was found where a numeric was
 expected
> >
> > How do I go about researching this so I can solve the problem?
> >
> > How can I at least find out which record it's choking on so I'd have a
> > fighting chance of fixing whatever is wrong?
> >
> > Is there a book? A web site? ANYTHING that will speed up the process?
> >
> >
> > Dennis Hancy
> > Eaton Corporation
> > Cleveland, OH
> >
> >
> > ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
 eb -----
> > http://newsone.net/ -- Free reading and anonymous posting to 60,000+
 groups
> > NewsOne.Net prohibits users from posting spam. If this or other
 posts
> > made through NewsOne.Net violate posting guidelines, email
> abuse_at_newsone.net
>
>
Received on Thu Apr 05 2001 - 21:08:42 CEST