Xquery Fails with ORA-00600: Internal Error Code, Arguments: [qmxqtmCompOccFromSchm:2]
(Doc ID 1563931.1)
Last updated on APRIL 12, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |