PLS-00801: internal error [phdcsql_canonical_sql]

Using a query like this:

INSERT INTO OM_DB.CDRS_VALIDOS_TMP (
  SELECT
  FROM (
    SELECT
    FROM (

      SELECT
      FROM (
        .....
      )

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. Received on Thu Apr 23 2009 - 11:10:27 CDT