I’m working on an Integration component that involves an “insert notification” on an oracle database. The problem I’m having is that any Oracle table with the datatype of “number” gets converted to a “Unicode String” in WM, and it seems to be losing the values to the right of the decimal.
I created a quick simple test table, inserted a value of 123.45 into a column defined as “number”, and the insert notification populates the value of 123. Has anyone else encountered this problem, and how did you overcome this.
Note: If the number has a precision (Number(22,3)) built into it, the JDBC adapter pulls the data properly into the appropriate field (ie Double)