Re: Oracle error -6550

A copy of this was sent to "Tim Kang" <timkang_at_stratfordinternet.com> (if that email address didn't require changing) On Fri, 26 Nov 1999 16:38:54 -0800, you wrote:

>Has anybody experienced this before?
>

Yes, hundreds of times/day in many cases.

06550, 00000, "line %s, column %s:\n%s" // *Cause: Usually a PL/SQL compilation error.

It is a very very generic error code that is followed by some more meaningful error message.

for example:

tkyte_at_8.0> declare
  2 garbage;
  3 begin
  4 null;
  5 end;
  6 /
garbage;

       *
ERROR at line 2:
ORA-06550: line 2, column 8:
PLS-00103: Encountered the symbol ";" when expecting one of the following: constant exception <an identifier>
<a double-quoted delimited-identifier> table LONG_ double ref char binary national character nchar
The symbol "exception" was substituted for ";" to continue.

6550 is followed by something that is useful. the 6550 is the high level error message meaning "plsql did not compile".

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Nov 26 1999 - 18:45:44 CST