Insert Select Statement Fails With Ora-600 [kokmcmp4: cannot compare two val] (Doc ID 1178563.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms


Insert Select query is failing with the error below:

ORA-00600: internal error code, arguments: [kokmcmp4: cannot compare two val], [], [], [], [], [], []

For example:

INSERT INTO X SELECT DISTINCT Y from XY;

Call Stack extracted from trace file looks similar to the one below:

kokmcmp <- qersoCompare <- smbput <- sorput <- qersoRowP
<- qerghFetch <- qersoFetch <- rwsfcd <- insfch <- insdrv
<- inscovexe <- insExecStmtExecIniE <- ngine <- insexe <- ngine
<- opiexe <- opipls <- opiodr <- rpidrus <- skgmstack
<- rpidru <- rpiswu2 <- rpidrv <- psddr0 <- psdnal
<- pevm_EXECC <- pfrinstr_EXECC <- pfrrun_no_tool <- pfrrun <- plsql_run
<- peidxr_run <- peidxexe <- kkxdexe <- kkxmpexe <- kgmexwi
<- kgmexec <- evapls <- evaopn2 <- qerocnFetch <- qerocFetch
<- opifch2 <- opifch <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- main <- libc_start_main <- start

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