XMLForest with a Union Caueses a Core Dump Error ORA-3113 or ORA-7445 (Doc ID 1079510.1)

Last updated on OCTOBER 12, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 to 11.1.0.7 - Release: 11.1 to 11.1
Information in this document applies to any platform.

Symptoms

Running a XMLForest query with Union clause on 11.1.0.7 causes a core dump.

SQL> select xmlforest(x) FROM (SELECT 1 x from dual union select 2 from dual);

ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 10620
Session ID: 170 Serial number: 5

Full Stack trace shows below functions:

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- ssexhd
<- 53552D49 <- evacssr <- kpofcr <- PGOSF584_qervwRow <- Procedure
<- qersoFetch <- qervwFetch <- opifch2 <- opifch <- opiodr <- ttcpip
<- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main <- libc_start_main <- start

This worked fine on 10.2.0.3, 10.2.0.4, 11.1.0.6 and 11.2.0.1

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