ORA-00600 [kokegPinLob1] Reported When The SQL Has Internal Function Like WMSYS.WM_CONCAT

(Doc ID 2273495.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

- The error ORA-00600 [kokegPinLob1] is reported when running a statement where WMSYS.WM_CONCAT is used:

SELECT A.ORGNZ_CD, '( ' || SUBSTR(D.REG_DD, 1, 4) || ' ' || SUBSTR(D.REG_DD, 5, 2) || ' ' || SUBSTR(D.REG_DD, 7, 2) || '  )' as REG_DD, B.ORGNZ_NM AS ORGNZ_NM, B.ORGNZ_NM || '' AS TEAM, A.RSP_DUTY_NM, A.RSP_DUTY_CTNT,
(SELECT wm_concat(X.PSCL_NM || TO_CHAR(RSP_TO_HDCNT,'90.99') |...

- Call stack seen in error trace file looks like below:

... kokegPinLob kokegCollectGarbageFromScalar kokegGarbageCollectRworo rworupo qersoFetch opifch2 opifch opiodr ttcpip opitsk opiino opiodr opidrv ...

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