Feature request or enhancement

For feature requests or enhancements, provide this information, please:

Which use case/requirement will be addressed by the proposed feature?

With Oracle connector, default is lob.enabled=fase

With this config, lob content is not streamed to Debezium nor read by initial snapshot, however there is a corner case: if CLOB content is under < ~1900 bytes, it is treated as VARCHAR and Debezium will read it. It should be discarded to be consistent with the data output.

Secondly, Debezium will inject text "__debezium_unavailable_value" or byte alternative of that. It would be better if this is just empty value

Implementation ideas (optional)

here:  https://debezium.zulipchat.com/#narrow/stream/348250-community-oracle/topic/LOB.20data.20handling