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

Bug report

For bug reports, provide this information, please:

[2022-09-15 21:00:51,681] DEBUG Processing DDL event create table test_json_clob(id char(3) primary key, content CLOB CONSTRAINT test_json_clob_ensure_json CHECK (content IS JSON)) (io.debezium.connector.oracle.xstream.LcrEventHandler:228)
[2022-09-15 21:00:52,445] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:31)
io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'create table test_json_clob(id char(3) primary key, content CLOB CONSTRAINT test_json_clob_ensure_json CHECK (content IS JSON));'
mismatched input 'JSON' expecting {'A', 'EMPTY', 'INFINITE', 'NAN', 'NOT', 'NULL', 'OF', 'PRESENT'}
        at io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:43)
        at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)
        at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)
        at org.antlr.v4.runtime.DefaultErrorStrategy.reportInputMismatch(DefaultErrorStrategy.java:327)
        at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:139)
        at io.debezium.ddl.parser.oracle.generated.PlSqlParser.unary_logical_expression(PlSqlParser.java)
        at io.debezium.ddl.parser.oracle.generated.PlSqlParser.logical_expression(PlSqlParser.java)
        at io.debezium.ddl.parser.oracle.generated.PlSqlParser.expression(PlSqlParser.java)

What Debezium connector do you use and what version?

oracle 1.8.1final

What is the connector configuration?

{
    "name": "oracle-test",
    "config":

{             "connector.class": "io.debezium.connector.oracle.OracleConnector",             "database.server.name": "CDC",             "database.hostname": "",             "database.port": "1521",             "database.user": "C##DBZUSER",             "database.password": "",             "database.dbname": "CDB19C",             "database.pdb.name": "PDB1",             "schema.include.list": "debezium",             "offset.storage": "org.apache.kafka.connect.storage.FileOffsetBackingStore",             "lob.enabled":"true",             "offset.flush.interval.ms": "6000",             "database.connection.adapter": "xstream",             "database.out.server.name" : "dbzxout",             "database.history.kafka.bootstrap.servers": "127.0.0.1:9092",             "database.history.kafka.topic": "oracle.history",             "key.converter.schemas.enable": "true",             "value.converter.schemas.enable": "true",             "snapshot.mode": "schema_only",             "provide.transaction.metadata": "true",             "transforms": "route",             "transforms.route.type": "org.apache.kafka.connect.transforms.RegexRouter",             "transforms.route.regex":"([^.]+)\\.([^.]+)\\.([^.]+)$",             "transforms.route.replacement":"$1.$2.ALL_TABLES",             "snapshot.locking.mode":"none"     }

}

What is the captured database version and mode of depoyment?

(E.g. on-premises, with a specific cloud provider, etc.)

oracle 19.3

What behaviour do you expect?

<Your answer>

What behaviour do you see?

<Your answer>

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

(Ideally, also verify with latest Alpha/Beta/CR version)

<Your answer>

Do you have the connector logs, ideally from start till finish?

(You might be asked later to provide DEBUG/TRACE level log)

<Your answer>

How to reproduce the issue using our tutorial deployment?

<Your answer>

Feature request or enhancement

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

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

<Your answer>

Implementation ideas (optional)

<Your answer>