Re: PLS-00801: internal error [phdcsql_canonical_sql]

From: CarlosAL <miotromailcarlos_at_netscape.net>
Date: Fri, 24 Apr 2009 04:08:52 -0700 (PDT)
Message-ID: <a8c642dc-793b-4ecd-899f-cd0443951784_at_g37g2000yqn.googlegroups.com>

On 23 abr, 18:12, Jorge Reyes <jorg_re..._at_hotmail.com> wrote:
> Hi again
>
> Using a query like this:
>
> INSERT INTO OM_DB.CDRS_VALIDOS_TMP (
>   SELECT
>   FROM (
>     SELECT
>     FROM (
>       SELECT
>       FROM (
>         .....
>       )
>     )
>     FULL OUTER JOIN
>     (
>       SELECT ....
>     )
>   )
> )
>
> I receive this errors:
>
> ORA-06550: line 0, column 0:
> PLS-00801: internal error phdcsql_canonicalize_sql:state, Batch 1 Line
> 1 Col 1
>
> Now, trust me, all the SELECT statement its ok, because i probe just
> that part and its working, but when i try to insert that set into the
> OM_DB.CDRS_VALIDOS_TMP table it doesnt work, i hear something about a
> bug on this version, thats my only clue, any idea?
>
> This are the oracle settings:
>
> "Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi"
> "PL/SQL Release 10.2.0.3.0 - Production"
> "CORE 10.2.0.3.0 Production"
> "TNS for Solaris: Version 10.2.0.3.0 - Production"
> "NLSRTL Version 10.2.0.3.0 - Production"
>
> Thanks in advanced.

'Using a query like this' is not acceptable.

Put the query and the DDL for the tables involved.

BTW:
>>" Now, trust me, all the SELECT statement its ok"

I'm NOT a believer.

Cheers.

Carlos. Received on Fri Apr 24 2009 - 06:08:52 CDT