-
Enhancement
-
Resolution: Done
-
Major
-
0.10.0.Beta4
-
None
-
Oracle 11g (11.2.0.4)
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
