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

Oracle: Add support for different representations of "NUMBER" Data Type

    XMLWordPrintable

Details

    Description

      I've been able to configure Oracle 11g and Debezium successfully.
      My Database schema has many tables with columns defined as "NUMBER", without specifying precision or scale, eg:

      CREATE TABLE SERVICES
       ( SERVICE_ID   NUMBER  NOT NULL );
      

      When I get this streamed into the Kafka topic, the scale is defined as 0 (zero) but there is no value.

      {
        "before": null,
        "after": {
          "Value": {
            "SERVICE_ID": {
              "scale": 0,
              "value": "\u0002\u001CO0"
            },
            ...
          }
        },
        "source": {
          "version": "0.10.0.Final",
          "connector": "oracle",
          "name": "netstream",
          "ts_ms": 1571045084752,
          "snapshot": {
            "string": "true"
          },
          "db": "db1",
          "schema": "SERVICE_OWNER",
          "table": "SERVICES",
          "txId": null,
          "scn": {
            "long": 776975
          },
          "lcr_position": null
        },
        "op": "r",
        "ts_ms": {
          "long": 1571045084758
        },
        "messagetopic": {
          "string": "netstream.SERVICE_OWNER.SERVICES"
        },
        "messagesource": {
          "string": "Debezium CDC from Oracle on netstream"
        }
      }
      

      I'd like to see the data!

      NB: The value held in the database for SERVICE_ID is: 35409711

      Attachments

        Issue Links

          Activity

            People

              jpechane Jiri Pechanec
              muirandy Andy Muir (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: