Select Query on a Composite Partitioned Table with Bind Variables Fails with ORA-01008
(Doc ID 1951776.1)
Last updated on FEBRUARY 22, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12cBETA2 [Release 11.2 to 12.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Select query on a composite partitioned table with bind variables
fails with ORA-01008.
Trace file may show the failing query and stack as:
ORA-01008: not all variables bound
----- Current SQL Statement for this session (sql_id=4z28p2hucjrra) -----
SELECT distinct TBL$OR$IDX$PART$NUM("TXN2", 0, 1, 0, "TXN_MINUTE") FROM
(SELECT ----- FROM <table name>
WHERE <column name> <TO_DATE(:B1) AND <column name> >=TO_DATE(:B2)) ORDER BY
1
----- Call Stack Trace -----
skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver <- dbgdaExecuteAction <- dbgdaRunAction
<-dbgdRunActions <- dbgdProcessEventActions <- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <- ksfpec <- dbgePostErrorKGE
<- 1129 <- dbkePostKGE_kgsf <- kgeselv <- ksesecl0 <- opiall0 <- opikpr <- opiodr <- rpidrus <- skgmstack <- rpiswu2
<- kprball <- kkpapiItOpen <- kkpapiItOpen <- kkpapItOpen <- kkoiiu <- kkofmx <- kkonxc <- kkotap <- kkojnp <- kkocnp
<- kkooqb <- kkoqbc <- apakkoqb <- apaqbdDescendents <- apaqbdList <- apaqbdDescendents <- apaqbdList <- apaqbd
<- kkqctCostTransfQB <- kkqctdrvJF <- kkqjfgdtr <- kkqctInterleaveJF <- kkqctdrvTE <- kkqtedtr <- qksqbApplyToQbc
<- kkqctdrvTD <- kkqtedrv <- kkqdrv <- kkqctdrvIT <- apadrv <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksSetBindType
<- kksfbc <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main <- libc_start_main <- start
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |