My Oracle Support Banner

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

Last updated on MARCH 08, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Cloud Schema 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
Oracle Database Cloud Exadata Service - Version N/A 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

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


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