ORA-07445: EXCEPTION ENCOUNTERED: CORE DUMP [] [] [] [] [] [] With No Argument List (Doc ID 1253894.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.1.0.6 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms

Following error would occur when a SQL is executed having partitioned table involved using multi column INLIST or OR operators.

ORA-07445: exception encountered: core dump [] [] [] [] [] []

The error would not have the argument list.

Only the associated trace file would have the function call stack.

The call stack shows the following:

Function List (to Full stack) (to Summary stack)

ksedst <- ksedmp <- ssexhd <- 000044C0 <- kkeadjts <- kkeits <- kkoiqb <- kkooqb <- kkoqbc <- apakkoqb <- apaqbd <- apadrv <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksSetBindType <- kksfbc <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- main <- start


Stack shows partitioning / dump in kkpapItGetAll().

Failing query has multi column inlist using literal replaced binds.

A dump can occur (in kkpapItgetAll) accessing a partitioned table using multi column INLIST.

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