ORA-00600 [qkswcInline1] in a Query With a WITH Clause on 11.1. (Doc ID 1063400.1)

Last updated on FEBRUARY 07, 2014

Applies to:

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

Symptoms


ORA-600 [qkswcInline1] is raised when parsing a complex query with a WITH clause, the stack trace would look like:

kgdsdst <- skdstdst <- dbkedDefDump <- ksfdmp <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE <- dbkePostKGE_kgsf <- kgeadse <- kgerinv_internal <- kgerinv <- kgeasnmierr <- qkswcInlineQBC <- qkswcChkList <- qkswcDriver <- qkswcDriver <- kkmdrvend <- kkmdrv <- opiSem

This can be tested with the following simple code:

SELECT 1 FROM
(
WITH
T1 AS (SELECT 1 FROM dual),
T2 AS (SELECT 1 FROM T1),
T3 AS (SELECT 1 as id FROM T1 UNION SELECT 2 FROM T1)
SELECT 1 FROM T2
);

It gives ORA-00600 [qkswcInline1] on 11.1 and a correct ORA-32035 on 10.2.

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