Issues Loading XML Message from JMS Queue to Oracle Table as Xmltype
(Doc ID 1139775.1)
Last updated on OCTOBER 19, 2023
Applies to:
Oracle Data Integrator - Version 10.1.3.5.6 and laterOracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.
Symptoms
A user is trying to load XML messages from IBM MQ to Oracle as Xmltype. The following is the details:
- Source: IBM MQ with xml messages as data defined in ODI as a JMS Queue Datastore with one column String 6000
- Record Separator: ACAC
- Field Separator: 24A324
- Target: Oracle the target column is Xmltype
- Mapping: XMLTYPE(JMS_Q.COL) executed on target Oracle.
In Topology>JMS>datatypes>String>Converted to for Oracle is changed from the default VARCHAR2 to CLOB
As with VARCHAR2, the C$ table creates the column as VARCHAR2 and it fails with:
These characters are causing the above error.
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! |