PLS-00801: internal error [phdcsql_canonical_sql]

[jreyesb]

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.

[LKBrwn_DBA]

Compilation of PL/SQL procedures/blocks can fail when they contain static sql which includes extra white space and/or comments. (Oracle bug)

A PLS-00801 from compiling a Stored Procedure is due to an ERROR in the canonical parsing Oracle is doing. Set the following event which is a "workaround" to the problem:

Add event="10946 trace name context forever, level 64" into the init.ora file used to start the instance.