XMLQuery with > 32 Attributes fails with ORA-07445: [qmxqcResolveQName()+308] (Doc ID 1988473.1)

Last updated on APRIL 12, 2022

Applies to:

Symptoms

Following error reported when using more than 32 attributes in xmlquery:
ORA-07445: exception encountered: core dump [qmxqcResolveQName()+308] [SIGSEGV] [ADDR:0x0] [PC:0xA4D262] [SI_KERNEL(general_protection)] []
 
Failing query:

SQL> SELECT XMLQUERY ('
 2          <juurikas
         v1="ABC" v2="ABC"  v3="ABC"  v4="ABC"  v5="ABC"  v6="ABC"  v7="ABC"  v8="ABC"  v9="ABC"  v10="ABC"
 3    4            v11="ABC"  v12="ABC"  v13="ABC"  v14="ABC"  v15="ABC"  v16="ABC"  v17="ABC"  v18="ABC"  v19="ABC"  v20="ABC"
 5            v21="ABC"  v22="ABC"  v23="ABC"  v24="ABC"  v25="ABC"  v26="ABC"  v27="ABC"  v28="ABC"  v29="ABC"  v30="ABC"
 6            v31="ABC"
 7            v32="ABC"
 8            (:
 9            v33="ABC"
10            :)
11          >
12          </juurikas>
13      '
14        RETURNING CONTENT) result_xml
15    FROM dual
16    ;
SELECT XMLQUERY ('
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 26496
Session ID: 355 Serial number: 18777

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.