ORA-600 [kkxlrd csid mismatch] With Wrong Usage Of CLOB Input To Function Which Is Expecting NCLOB (Doc ID 1470040.1)

Last updated on JUNE 30, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

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 gwh.Export_Xml_Data.process_sphh" */ INTO GWH.EXPXMLDATA (XMLDATA, ID_EXPCLIENTCOMPANY, ID_COMPANY, EXPORTTYPE, ID_SHIPMEXPORTDESTINATION, DATE_INSERTED, SEQUENCENO) SELECT EXPORT_XML_DATA.GETUNICLOB(XMLSERIALIZE(CONTENT XMLELEMENT( "Shipment", XMLFOREST( ID_CLIENTORDER "ID_ClientOrder", EXTSYSTIDWAREHOUSE "ExtSystIDWarehouse", INTERNALCUSTOMERNUMBER "InternalCustomerNumber", EXTERNALCUSTOMERNUMBER "ExternalCustomerNumber", TO_CHAR(INVOICEDATE, 'dd.mm.yyyy') AS 

....

....

 ----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0xe2eb7ba8      1064  package body SYS.DBMS_LOB
0x9ee06aa8        27  package body GWH.EXPORT_XML_DATA
0x9ee06aa8       490  package body GWH.EXPORT_XML_DATA
0x9ee06aa8      1415  package body GWH.EXPORT_XML_DATA
0xd0999af0         1  anonymous block
0xf48c88e0      2879  package body SYSP.APPLFW
0xf48c88e0      3257  package body SYSP.APPLFW
0xd5d1ee78       153  package body WHCOMM.EXPORT_FW
0xe25ef780         4  anonymous block

 

 

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

 

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