Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4994

CLOB with single quotes causes parser exception

XMLWordPrintable

      While setting a CLOB field with the following value:

      2"''" sd f""" '''''''' ''''
      

      the following exception is thrown:

      Caused by: io.debezium.text.ParsingException: Failed to parse operator at index 221: DECLARE 
       loc_c CLOB; 
       buf_c VARCHAR2(6396); 
       loc_b BLOB; 
       buf_b RAW(6396); 
       loc_nc NCLOB; 
       buf_nc NVARCHAR2(6396); 
      BEGIN
       select "COLUMN2" into loc_c from "VNSOCIAL_DATA"."Z_TEST_CDC_CLOB" where "COLUMN1" = '2"''" sd f""" '''''''' ''''' for update;
          at io.debezium.connector.oracle.logminer.parser.SelectLobParser.parseOperator(SelectLobParser.java:235)
          at io.debezium.connector.oracle.logminer.parser.SelectLobParser.parseWhere(SelectLobParser.java:192)
          at io.debezium.connector.oracle.logminer.parser.SelectLobParser.parse(SelectLobParser.java:73)
          ... 16 more
      

      Taken from latest comments on DBZ-4891

              ccranfor@redhat.com Chris Cranford
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: