My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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) -----

The call stack looks similar to:

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

The bind variable information shows:

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

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:


To view full details, 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 a vibrant support community of peers and Oracle experts.