Re: List of Oracle Errors

From: GHouck <hksys_at_teleport.com>
Date: 2000/05/24
Message-ID: <392C764B.55D6@teleport.com>#1/1

I found the following in a Doc/Help page (about Migration?):

  \orant\doc\database.804\a58243\migo7app.htm

---

Keyword Behavior Differences: Version 7 vs. Version 8

The following keywords or types included in both version 7 and version 8 produce slightly different error message identifiers when used as a function name in a SELECT list:

 Keyword
   CHARACTER, COMMIT, DEC, FALSE, INT, NUMERIC, REAL, SAVEPOINT, TRUE  Version 8 Behavior
   Generates errors: ORA-06550 and PLS-00222

 Version 7 Behavior
   Generates errors: ORA-06552 and PLS-222 <<<<<< YOUR ERROR?

In version 8, each may be used as a function name in a SELECT list, however, if it is qualified with a schema, as schema.function, as in the following example: elect scott.true() ...

In version 8, if a schema qualification is missing, these words generate an error, while, in version 7, their unqualified use functions without error.

---

It sounds like they are the error messages from using one of the Reserved Keywords for Function Names ... but I'm not clear on it.

Also,

---

From Oracle Documentation:

---

PL/SQL is Oracle's procedural extension to SQL, the standard database access language. A full-fledged programming language, PL/SQL offers modern software engineering features such as data encapsulation, overloading, exception handling, and information hiding. PL/SQL also offers seamless SQL access, tight integration with the Oracle server and tools, portability, and security.

---

Good Luck,

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys

Steve . wrote:
>
> Excuse a novice. What would PL/SQL errors mean? We are trying to
> find out if it's something related with the database tables, or the
> Windows software connecting on the other end. The people who made the
> software are not very helpful, and I'm just starting to pick up on
> Oracle. Thanks the the help.
>
> Steve
>
> On Wed, 24 May 2000 15:00:53 -0700, GHouck <hksys_at_teleport.com> wrote:
>
> >Steve . wrote:
> >>
> >> I have Oracle 8i and on occasion get ORA- error messages. Is there
> >> somewhere that list each error message and what is actually causing
> >> this? It would save a lot of troubleshooting time. I have several
> >> DBA and Troubleshooting books and they only seem to list a few. Right
> >> now I'm getting the following:
> >>
> >> ORA-06552
> >> ORA-06553
> >>
> >> Thanks.
> >>
> >> Steve
> >>
> >> Newsgroup replies preferred. Remove nospam when replying thru email.
> >
> >Have you looked in your copy of ORA.HLP (it contains error messages,
> >at least under 8.0.5 and 7.3.x)? However, I noticed that 6552 and 6553
> >are missing, but the ones on either side are PL/SQL errors.
> >
> >Yours,
> >
> >Geoff Houck
> >systems hk
> >hksys_at_teleport.com
> >http://www.teleport.com/~hksys
Received on Wed May 24 2000 - 00:00:00 CDT