DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: PLS-00801: internal error [phdcsql_canonical_sql]

  1. #1
    Join Date
    Apr 2009
    Posts
    3

    PLS-00801: internal error [phdcsql_canonical_sql]

    Hi again

    Using a query like this:

    Code:
    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.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool No comment(s)

    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.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width