With clause sub-query having views failing with ORA-979 on 12.1.0.2 (Doc ID 2580678.1)

Last updated on AUGUST 28, 2019

Applies to:

Symptoms

With clause sub-query having views failing with ORA-979

Query syntax may look like below..

WITH tab AS (
            SELECT col1
            FROM (
                SELECT MAX(col1) col1
                FROM schema1.tab1
                WHERE col2 = 'XYZ'
                )
            )
        ,tab2 AS (
            SELECT ..
            )
        ,tab3 AS (
            SELECT ..
            )
        ,tab4 AS (
            SELECT ..
            )
        ,tab4 AS (
            SELECT ..
            FROM schema1.tab1 gl
            INNER JOIN ..
                ...
            GROUP BY gl.col1
                ..
                ,CONCAT (
                    'O_'
                    ,CONCAT (
                        REGEXP_REPLACE(...)
                        ,gl.xyz
            ..
        ,gl_fte AS (
            SELECT ..
            )
SELECT ..
UNION ALL
SELECT ..
GROUP BY ..
UNION ALL
SELECT ..
GROUP BY ..;

Changes

Call Stack    kkqctdrvTD <- kkqdrv <- kkqctdrvIT  >> Matching with bug 29990369

skdstdst <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver <- dbgdaExecuteAction <- dbgdaRunAction <- dbgdRunActions <-
dbgdProcessEventAct <- ions <- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <-
ksfpec <- qecgoc <- qecsel  <- qecpqbcheck <- qecpqbcheckNSE <- kkqtutlCheckGroupBy <- kkqvmValidCVM <- kkqvmTrMrg
 <- kkqvmTrMrg <- kkqvmTrMrg <- kkqvmTrMrg <- kkqvmdrv2 <- kkqctdrvTD
            <- kkqdrv <- kkqctdrvIT <- apadrv <- opitca <- kksLoadChild
             <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0
              <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino
               <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain
                <- main <- libc_start_main <- start

Cause

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