ORA 600 [qmnfaExecCheckPos2] for XMLTABLE query (Doc ID 1953946.1)

Last updated on DECEMBER 14, 2014

Applies to:

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

Symptoms

Following error reported in alert.log for a query with XMLTABLE:

Thu May 22 11:31:43 2014
Errors in file /oracle/diag/rdbms/infp/INFP/trace/INFP_s003_28818.trc (incident=345):
ORA-00600: internal error code, arguments: [qmnfaExecCheckPos2], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/infp/INFP/incident/incdir_345/INFP_s003_28818_i345.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

 

Failing query:

SELECT CV.CHAPTERNO,
DECODE(CV.SECCHECKVERID,NULL,X.CHECKNAME,CV.CHAPTERNAME)
CHAPTERNAME,X.TAGCNT, X.CUSTCOMPL CUSTCOMPLIANT,X.PCICOMPL PCICOMPLIANT FROM
REPORTS R, XMLTABLE('for $v in /secdata/result
  2  return $v' PASSING R.REPORTXML COLUMNS CHECKNAME VARCHAR2(100) PATH
'./@id', CUSTCOMPL VARCHAR2(20) PATH './CUSTCOMPLIANT[1]/text()', PCICOMPL
VARCHAR2(20) PATH './PCICOMPLIANT[1]/text()', TAGCNT NUMBER PATH
'count(./VALUE)') X, SECCHECKS SC, SECCHECKVERSIONS CV WHERE R.REPORTID=64
AND X.CHECKNAME=SC.CHECKNAME(+) AND CV.SECCHECKID=SC.SECCHECKID AND
CV.VERSIONID=R.DIRECTIVE_VERSIONID ORDER BY CV.POS;

+Error stack:

qmnfaExecCheckPosPredicate qmnfaEvtStartNode qmnfaEvtNextMatch qmnfaNextMatch
qerxpFetch qerjotFetch rwsfcd qerhjFetch rwsfcd qerhjFetch qersoProcessULS
qersoFetch opifch2 opifch opipls opiodr rpidrus skgmstack rpiswu2 rpidrv
psddr0 psdnal pevm_BFTCHC pfrinstr_BFTCHC pfrrun_no_tool pfrrun plsql_run
peicnt kkxexe

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