Re: PLS-00801: internal error [phdcsql_canonical_sql]
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 23 Apr 2009 16:54:33 -0500
Message-ID: <zu5Il.12688$jZ1.3234_at_flpi144.ffdc.sbc.com>
Jorge Reyes 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.
Date: Thu, 23 Apr 2009 16:54:33 -0500
Message-ID: <zu5Il.12688$jZ1.3234_at_flpi144.ffdc.sbc.com>
Jorge Reyes 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.
Does the tmp table have all of the correctly defined columns from the resulting select...?
Are you using Warehouse Builder?
http://forums.oracle.com/forums/thread.jspa?threadID=483857
but sounds like it could be bug related. Received on Thu Apr 23 2009 - 16:54:33 CDT