In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.

Bug report

We use Debezium oracle logminer connector to stream data from oracle to apache kafka.

we work on tables that contain columns of type sys.XMLTYPE.

When starting the connector, it reads the xml columns without a problem during the snapshot, while streaming, it doesn't capture any event of operation update specifically on xml columns from many tables and works in some other tables despite that they have the same structure.

Another behavior noticed, if there is Insert operation, xml field comes as null where it is the opposite.

What Debezium connector do you use and what version?

Oracle connector logminer.

2.1.2

What is the connector configuration?

{
  "name": "connector",
  "config":{
"connector.class": "io.debezium.connector.oracle.OracleConnector",
"tasks.max": "1",
"key.converter": "io.confluent.connect.avro.AvroConverter",
"value.converter": "org.apache.kafka.connect.json.JsonConverter",
"topic.prefix": "DB",
"database.hostname": "x.x.x.x",
"database.port": "1521",
"database.user": "DBZUSER",
"database.password": "DBZ",
"database.dbname": "dbzsid",
"database.connection.adapter": "logminer",
"log.mining.strategy": "online_catalog",
"snapshot.locking.mode": "none",
"lob.enabled": "true",
"internal.log.mining.transaction.snapshot.boundary.mode": "all",
"table.include.list": "schema.table1, schema.table2,schema.table3",
"schema.history.internal.kafka.bootstrap.servers": "broker:29092",
"schema.history.internal.kafka.topic": "schema-changes.dbz",
"value.converter.schemas.enable": "false",
"key.converter.schema.registry.url": "http://schema-registry:8081"   
}
}

What is the captured database version and mode of depoyment?

Oracle 19 ee

On-premise

What behaviour do you expect?

capturing events of update ops on xmltype columns in all tables.

insert op event comes with xmltype field as null where it not.

What behaviour do you see?

events get captured from some tables and not from others when updating XMLTYPE column.

Do you see the same behaviour using the latest relesead Debezium version?

2.2.0.Alpha1