Error while parsing XMLTYPE column in oracle

[Muhammad Salah El-Okda]

Hi, I am trying to get the cdc logs from logminer using Debezium 2.7 from oracle db 19c and the XMLTYPE is stored in basicFile.

I am using lob.enabled = True.

the error is 

ERROR [t24_1table|task-0] Mining session stopped due to error. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:262)
io.debezium.text.ParsingException: Parsing failed for SQL: 'update "schema"."table" a set a."XMLRECORD" = XMLType(:1) where a."RECID" = '123';'

[Chris Cranford]

Hi -

Please raise a Jira [1] and include the table's DDL, the exact SQL to insert and update the row that you're using so we can reproduce it, and the complete log with error. It seems the SQL has bind parameters, which is highly unusual, but this could be a corner case.

Thanks,
-cc

[1]: https://issues.redhat.com/projects/DBZ

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/debezium/71719e74-b668-4280-9166-fbb1c816c029n%40googlegroups.com.