ORA-600[qknrSetCntForOpn:bfl for bind] Running a Query with Bind Variables (Doc ID 2463110.1)

Last updated on OCTOBER 03, 2023

Applies to:

Symptoms

In 12.2.0.1.0, given this setup:

     create table <TABLE_NAME1> ( COL1 CHAR(1 BYTE) primary key,COL2 VARCHAR2(20 BYTE));
     create table <TABLE_NAME2> (COL3 VARCHAR2(20 BYTE) primary key, COL4 VARCHAR2(20 BYTE));

     insert into <TABLE_NAME1> values(1,'<VALUE>');
     insert into <TABLE_NAME1> values(2,'<VALUE>');
     insert into <TABLE_NAME1> values(3,'<VALUE>');
     insert into <TABLE_NAME1> values(4,'<VALUE>');
     insert into <TABLE_NAME1> values(5,'<VALUE>');
     insert into <TABLE_NAME1> values(6,'<VALUE>');
     insert into <TABLE_NAME1> values(7,'<VALUE>');

     insert into <TABLE_NAME2> values('<VALUE1>','<VALUE2>');
     insert into <TABLE_NAME2> values('<VALUE1>','<VALUE2>');
     insert into <TABLE_NAME2> values('<VALUE1>','<VALUE2>');
     insert into <TABLE_NAME2> values('<VALUE1>','<VALUE2>');
     insert into <TABLE_NAME2> values('<VALUE1>','<VALUE2>');

The following error occurs in SQL*Plus:

This same issue occurs via ODP.NET.

Changes

The database was upgraded to 12.2.0.1.  (This error did not occur prior to 12.2.0.1.)

Cause

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