Sql Errors with ORA-07445: Exception Encountered: Core Dump [kkocnvl()+881] (Doc ID 2586724.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• Error in the alert log:
  ORA-07445: exception encountered: core dump [kkocnvl()+881] [SIGSEGV] [ADDR:0x0] [PC:0x1041E8C1] [Ad
  Error Stack: ORA-7445[kkocnvl]
  Main Stack:
  kkocnvl <- kkqoreCheckQBValidity <- kkqctCheckTransValid <- kkqctcvqb <- kkqctcvqb
  <- kkqctcvct <- kkqctChkCBQTvalid <- kkqdrv <- opiSem <- opiprs <- kksParseChildCursor
  <- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor
  <- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o
  <- opimai_real <- ssthrdmain <- main
   
• Example of testcase:  
  STEPS
  -----------------------

  (1) Version 11.2 
  ------------------------
  SQL> create table tt (no number,name varchar2(10));

  SQL> select * from tt where name=to_char();
  select * from tt where name=to_char()
  *
  ERROR at line 1:
  ORA-00938: not enough arguments for function

  (2) Version 12.2 
  ------------------------
  SQL> create table t2 (no number,name varchar2(10));
  Table created.
  SQL> insert into t2 values(1,'aa');
  1 row created.
  SQL> insert into t2 values(2,'bb');
  1 row created.
  SQL> insert into t2 values(3,'cc');
  1 row created.
  SQL> commit;
  Commit complete.
  SQL> select * from t2 where name=to_char(null);
  no rows selected
  SQL> select * from t2 where name=to_char(aa);
  select * from t2 where name=to_char(aa)
  *
  ERROR at line 1:
  ORA-00904: "AA": invalid identifier
  SQL> select * from t2 where name=to_char(NULL);
  no rows selected
  SQL> select * from t2 where name=to_char('cc');
  NO NAME
  ---------- --------------------
  3 cc
  SQL> select * from t2 where name=to_char('CC');
  no rows selected
  SQL> select * from t2 where name=to_char(); <<<<<<<<<<<<-- ORA-7445 [kkocnvl] produced
  select * from t2 where name=to_char()
  *
  ERROR at line 1:
  ORA-03113: end-of-file on communication channel

  alter session set "_optimizer_cbqt_or_expansion"=off When using, ora-7445 error as above does not occur. However, the following error occurred.
  SQL> alter session set "_optimizer_cbqt_or_expansion"=off;
  Session altered.
  SQL> select * from t2 where name=to_char();
  select * from t2 where name=to_char()
  *
  ERROR at line 1:
  ORA-00938: not enough arguments for function

  ORA-7445[kkocnvl] returned when executing a simple query containing a call
  to to_char with no arguments. ORA-938 should be returned instead.

    
  

   

Cause

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