ORA-600 [kkxlrd csid mismatch] With Wrong Usage Of CLOB Input To Function Which Is Expecting NCLOB
(Doc ID 1470040.1)
Last updated on MARCH 01, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Cloud Schema 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
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
NOTE: In the SQL statements bellow, the user information and metadata used represents fictitious data.
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
Symptoms
The following errors are reported in the alert log:
ORA-00600: Interner Fehlercode, Argumente: [kkxlrd csid mismatch], [871], [46], [2], [1], [], [], [], [], [], [], []
There may or may not be a current SQL reported in the incident trace file:
INSERT /*+ "Package <schema>.<package_name>.<function_name>" */ INTO <schema>.<table_name> (......
....
....
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xe2eb7ba8 1064 package body SYS.DBMS_LOB
0x9ee06aa8 27 package body <SCHEMA>.<PACKAGE_NAME>
Call stack:
skdstdst ksedst1 ksedst dbkedDefDump ksedmp ksfdmp dbgexPhaseII dbgexProcessError
dbgeExecuteForError dbgePostErrorKGE dbkePostKGE_kgsf kgeadse kgerinv_internal kgerinv
kgeasnmierr kkxlrd kkxlcrd pevm_icd_call_commo pfrinstr_ICAL pfrrun_no_tool pfrrun
plsql_run peidxr_run peidxexe kkxdexe kkxmpexe kgmexwi kgmexec evapls evaopn2 evaopn2
qesltcEvalOutofLineCols qesltcBeforeRowProcessing qerltcNoKdtBuffered InsRowCBK
qerltcLoadStateMachine qerltcInsertSelectR qertbFetchByRowID rwsfcd qerltcFetch insexe
opiexe opipls opiodr rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal pevm_EXECC
pfrinstr_EXECC pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe opipls opiodr
rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool
pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv
sou2o opimai_real ssthrdmain main libc_start_main start
dbgeExecuteForError dbgePostErrorKGE dbkePostKGE_kgsf kgeadse kgerinv_internal kgerinv
kgeasnmierr kkxlrd kkxlcrd pevm_icd_call_commo pfrinstr_ICAL pfrrun_no_tool pfrrun
plsql_run peidxr_run peidxexe kkxdexe kkxmpexe kgmexwi kgmexec evapls evaopn2 evaopn2
qesltcEvalOutofLineCols qesltcBeforeRowProcessing qerltcNoKdtBuffered InsRowCBK
qerltcLoadStateMachine qerltcInsertSelectR qertbFetchByRowID rwsfcd qerltcFetch insexe
opiexe opipls opiodr rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal pevm_EXECC
pfrinstr_EXECC pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe opipls opiodr
rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool
pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv
sou2o opimai_real ssthrdmain main libc_start_main start
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |