ORA-00600 [Qmxptevlxpo2] from a WITH select (Doc ID 1413803.1)

Last updated on OCTOBER 04, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

The following sql statement

WITH dep AS
  (SELECT *
   FROM
     (SELECT EXTRACTVALUE (VALUE (t), '//OBJ') obj ,
             EXTRACTVALUE (VALUE (t), '//OBJ_WHERE') obj_where,
             EXTRACTVALUE (VALUE (t), '//DEP_OBJ') dep_obj ,
             EXTRACTVALUE (VALUE (t), '//DEP_WHERE') dep_where
      FROM ddxml d,
           TABLE ( XMLSEQUENCE ( EXTRACT (d.dd, '/TABDEF/DEPENDENCIES/DEPENDENCY'))) t
      WHERE jobid = 2228
     )
  )
SELECT *
FROM dep
WHERE OBJ =
   (SELECT DEP_OBJ
    FROM dep
    WHERE OBJ = 'convAuditmaster_Altered'
    AND DEP_WHERE = 'VIEW'
   )


Fails with

ORA-00600: internal error code, arguments: [qmxptEvlXPO2], [], [], [], []


The call stack is:

kgeasnmierr <- qmxptEvalXPOut <- evaopn2 <- qervwRowProcedure <- qerxpFetch
<- qervwFetch <- qerjotFetch <- rwsfcd <- qerltFetch <- insdlexe

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms