Backport Request For Bug 14380605 On IBM Linux On System Z (Doc ID 2105388.1)

Last updated on FEBRUARY 10, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

ORA-01008 occurs and trace file shows SELECT 1 from dual on 12.1.0.2.
The following will show in the trace file:

 

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
ORA-01008: not all variables bound
----- Current SQL Statement for this session (sql_id=9ypua5j3jmcgn) -----
SELECT 1 FROM DUAL WHERE m.obj# = :objn and (:pobjn = 0 or
m.obj# = :pobjn or m.obj# in (select obj#
from tabpart$ where bo# = :pobjn a
nd obj# = :objn union all select obj#
from tabcompart$ where bo
# = :pobjn and obj# = :objn union all se
lect tsp.obj# from tabsubpart$ tsp, tabcompart$ tcp
where tsp.pobj# = tcp.obj# and (tcp.bo# = :pobjn or tcp.obj# = :pobjn)
and tsp.obj# = :objn))
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
3c3faf8f8 1906 package body SYS.DBMS_STATS
3c3faf8f8 44040 package body SYS.DBMS_STATS
3c3faf8f8 44256 package body SYS.DBMS_STATS

 

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