My Oracle Support Banner

OGG Replicat Abend - "SQL error 64464: invalid use of xmlns as a prefix " (Doc ID 2557821.1)

Last updated on JULY 02, 2019

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

 Replicat abend with below error :

2019-04-05 14:37:13  WARNING OGG-01154  SQL error 64464 mapping 
ABCD.AAAA_RESULT_XML to DERD.BBBB_RESULT_XML OCI 
Error ORA-64464: XML event error 
ORA-19202: Error occurred in XML processing 
In line 28 of orastream: 
LPX-00290: invalid use of xmlns as a prefix (status = 64464), SQL <INSERT 
INTO "DERD.BBBB_RESULT_XML OCI" 
("BBBB_RESULT_ID","RESULT_LOG_DATE","PRE_RESULT_BODY_XML","RESULT_BODY_ 
XML","TRANSACTION_TYPE_SOURCE","TRANSACTION_TYPE_TARGET","TRANSACTION_APPLIED_ 
TIMESTAMP","TRANSACTION_SEQ","TRANSACTION_COMMIT_SCN","TRANSACTION_CREATE_TIME 
STAMP","TRANSACTION_CREATED_BY") VALUES 
(:a0,:a1,sys.xmltype.createxml(:a2,null,1,1),sys.xmltype.createxml(:a3,null,1, 
1),:a4,:a5,:a6,:a7,:a8,:a9,:a10)>. 

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
Cause
Solution

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