Xquery Fails with ORA-00600: Internal Error Code, Arguments: [qmxqtmCompOccFromSchm:2] (Doc ID 1563931.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

the following XQuery statement

SELECT XmlType.getClobVal(COLUMN_VALUE) FROM XMLTABLE( '
(:INIT LOCAL FUNCTION DECLARATION:)(:END LOCAL FUNCTION DECLARATION:) (
let $Data_data:=xs:date(''2013-05-20'')
let $macro_relazione_data:=xs:string(''2011_06_30 1 TTF_SA FIX_hub'')
let $queryValue:=(collection("oradb:/BASVI/TEST2/ROW[(
COLLECTION=''|basvi|ntt_risk_management2|values|RelHub_HCV4_1|actual'' ) and
(NAMERESOURCE=''20130520(1051430873)+201106301TTFSA(1306764780)+''
)]/VALUE"))/element()[1]
for $input at $i in $queryValue
let $xml:=$input/xmlValue/RelHub_HCV4
return

{$xml/row}


)
' ) tmp
;


fails with error

SELECT XmlType.getClobVal(COLUMN_VALUE) FROM XMLTABLE( '
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qmxqtmCompOccFromSchm:2], [],
[],[], [], [], [], [], [], [], [], []

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