Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySQL decimal(p, s) datatype not captured properly on migration

Allain LegacyJan 18 2024

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

Comments
Post Details
Added on Jan 18 2024
0 comments
204 views