PLS error 00801: internal error [25200]

From: Kal Khatib <kkhatib_at_cisco.com>
Date: Mon, 10 Aug 1998 16:00:57 -0700
Message-ID: <35CF7BA9.CBDD8377@cisco.com>

I try to declare a cursor that has a complex select statement. When I compile
I get PLS-00801 error. When I replace the select with a simple (sleect sysdate from dual)
the package compiles.

the statement I'm using is something like:

SELECT    a,
          b,
          c,
          sum (x),
          sum(y)
FROM    (SELECT some_fields
                FROM tables
                WHERE conditions)     t1,


                (SELECT some_fields


                FROM tables
                WHERE conditions)    t2,


                (SELECT some_fields


                FROM tables
                WHERE conditions)    t3

WHERE conditions
GROUP BY a,b,c
ORDER BY a,b,c

the statement runs perfectly in SQLPLUS prompt. The DBA could not help me out.

the specific error message I get is

LINE/COL ERROR

0/0 PLS-00801: internal error [25200] Elapsed: 00:00:00.01

so the error is at line/col 0/0!!!

could it be some misplaced quotes etc?

help greatly appreciated.
thanks
Kal. Received on Mon Aug 10 1998 - 18:00:57 CDT