My Oracle Support Banner

ORA-600 [kghalo2] When Using a VARCHAR2 Parameter in Pro*C (Doc ID 338482.1)

Last updated on APRIL 06, 2020

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


You get the error:
ORA-00600: internal error code, arguments: [kghalo2], [0x0], [], [], [], [], [], []
Stack : kghalo kpuhhalo ttcrbur ttcbur kpctor ttca2p
In the trace file, the current cursor shows one of the bind parameters similar to:
 bind 5: dty=96 mxl=4882(4882) mal=00 scl=00 pre=00 oacflg=00 oacfl2=1 size=4000 offset=0
bfp=b725301c bln=4000 avl=-336 flg=05
with a long value.
Note that mxl is greater than the maxsize for VARCHAR2.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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