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: PLS 00801 error: internal error. What causes it?

Re: PLS 00801 error: internal error. What causes it?

From: Kal Khatib <kkhatib_at_cisco.com>
Date: 1998/08/13
Message-ID: <35D3214E.70F6E04E@cisco.com>#1/1

I resolved the problem.
I have a cursor declaration which is a select statement with 3 sub-selects. 2 of those use the astrisk (*) to select everything from a table.
According to Oracle tech support, this is a bug in PL/SQL, and the work around is to spell out all the
fields in the statement.
Kal.

Kal Khatib wrote:

> I'm getting PLS 801 error in my code. I'm clueless why.
>
> There is a cursor declaration, that, if I comment out, the package
> compiles.
> But I have no clue why the declaration would cuase the error.
> any help appreciated.
> thanks
> Kal.
Received on Thu Aug 13 1998 - 00:00:00 CDT

Original text of this message

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