Error ORA-01461 while saving XML in XMLType column using JDBC Sink Connector

Kafka Connect Managed Connectors
1

I have some XML data as string in my Kafka message and I am trying to save it to Oracle XML DB using JDBC Sink Connector.
I am getting error when trying to save XML in XMLType column.

ORA-01461: can bind a LONG value only for insert into a LONG column

It seems this error comes when the data is more than 4000 chars and in my case it is almost every time more than 4000 chars.
Is there a way to fix this error?

2

I tried inserting the same XML directly in database and it was successful. It seems to be an issue with JDBC connector which dosen’t seem to allow more than 4000 chars in XMLType.

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.