Re: PLS error 00801: internal error [25200]

From: Roger Burrows <roger.burrows_at_amd.com>
Date: Tue, 11 Aug 1998 17:35:08 -0500
Message-ID: <6qqgut$474$1@amdint.amd.com>

What is the Oracle (and the PL/SQL) version involved? What's the o/s? = I've seen a similar problem with a nested query caused by a bug on = Solaris and Oracle 7.2.

    Kal Khatib wrote in message <35CF7BA9.CBDD8377_at_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 Tue Aug 11 1998 - 17:35:08 CDT