ORA-600 [kghstack_alloc], [koklsotyopn alloc] on INSERT (Doc ID 1404149.1)

Last updated on OCTOBER 25, 2013

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.2.0 and later
Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 35-Oct-2013***

Symptoms

Encountering ORA-600 [kghstack_alloc], [koklsotyopn alloc] during INSERT.

The following error is seen in the ALERT:

ORA-00600: internal error code, arguments: [kghstack_alloc], [koklsotyopn alloc], [], [], [], [], [], [], [], [], [], []


From the generated tracefile the following information is available.

Current sql:

----- Current SQL Statement for this session (sql_id=6w1hv8d7fuzfc) -----
INSERT INTO TABLE1 (COL1,COL2) VALUES (:1,:2)


The call stack looks similar to:

----- Call Stack Trace -----
kghstack_alloc koklsotyopn kokleva evaopn2


The bind variable information shows:

COL1:
Bind#0 oacdty=02 mxl=22(22)

COL2:
Bind#1 oacdty=01 mxl=2000(21408)            <----------- max length : 2000, though application tries to insert 21408


Checking the table structure of table TABLE1 shows COL2 is of type CLOB:

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