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

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

    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

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  jpechanec Jiri Pechanec
                  Reporter:
                  muirandy Andy Muir
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: