The source database has fields defined as DECIMAL(13,6)
yet the captured table reported in the tool reports it as DECIMAL(0, 6)
. As a result, when the migration generates the master.sql
file with the schema DDL it produces columns defined as NUMBER(0, 6)
which produces an error:
MY_FIELD_NAME NUMBER(0,6),
*
ERROR at line 13:
ORA-01727: numeric precision specifier is out of range (1 to 38)
This is the source table column definition:
`MY_FIELD_NAME` decimal(13,6) DEFAULT NULL,
SQL Developer version: Oracle IDE 23.1.1.345.2114
MySQL connection: mysql-connector-j-8.2.0.jar