ORA-03113 Generated When Querying XMLTYPE Data (Doc ID 1556865.1)

Last updated on JULY 27, 2016

Applies to:

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

Symptoms

While executing select XQuery failed with following errors:

select
l.PW_CLAIM_TYPE
from PWAYWORKFILE_TABLE,
xmltable(
xmlnamespaces(DEFAULT 'http://www.xxxx.com/Pathways/Workfile'
, 'http://www.xxxx.com/Pathways/CommonType' as "pct")
, '$XS/PwayWorkfile' passing WORKFILE as "XS"
columns
PW_CLAIM_TYPE VARCHAR2(100) PATH 'ClaimType'
) l

This will throw an error message like below,

ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 10363
Session ID: 15 Serial number: 3644

Following error reported in alert log:

ORA-07445: exception encountered: core dump [kokax_create_lobstream()+56] [SIGSEGV] [ADDR:0x8] [PC:0x696693C] [Address not mapped to object] []

Stack Trace: skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp        <- ssexhd <-
sighandler <- kokax_create_lobstr <- eam <- kokax_add_column         <- 1329
<- kokardc <- kdsoprpcb <- kdsgrp_cb <- ktrexc          <- kcbgtcr

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