ORA 7445 [qmxtr2CollectPreds_rec] when using XMLindex (Doc ID 2503960.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

When using XMLINDEX, following query fails:

with s1 as

( select null from test,

xmltable('data' passing a_xml columns a_inner_xml xmltype path 'inner_xml' ) a,

xmltable('inner_xml' passing a_inner_xml columns a_inner_xml xmltype path 'inner_data' ) b ),

s2 as ( select null from test, xmltable('data' passing a_xml columns a_inner_xml xmltype path 'inner_xml' ) )

select * from s1,s2;

/

with s1 as

*

ERROR at line 1:

ORA-03113: end-of-file on communication channel

Process ID: 19007

Session ID: 1575 Serial number: 65454

Alert.log has:

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x10] [PC:0x8559B5D, qmxtr2CollectPreds_rec()+61] [flags: 0x0, count: 1]
Errors in file ...................
ORA-07445: exception encountered: core dump [qmxtr2CollectPreds_rec()+61] [SIGSEGV] [ADDR:0x10] [PC:0x8559B5D] [Address not mapped to object] []

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.