[DDLUTILS-263] JDBC type NUMERIC - Database type NUMBER - But "Will be read back as DECIMAL"!?

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Core - Oracle
• Assignee: Thomas Dudziak
• Reporter: Shant Bozian
• Created: 08/Sep/10 09:45
• Updated: 08/Sep/10 09:45

Description

I am using the Ddlutils API to migrate a database model from Sybase to Oracle.

The IDENTITY columns (of NUMERIC type) I have in Sybase are being migrated to Oracle with the proper behaviour: creation of a sequence and a trigger on those columns, with the type conversion from NUMERIC to NUMBER.

However, when going back from Oracle to Sybase, I cannot retrieve those IDENTITY columns because of the following problem: NUMBER in Oracle is read back as DECIMAL which causes the following error in Sybase during the table creation:

Identity field [..] must be a numeric with a scale of 0. It may not be nullable or encrypted.

I don't understand the purpose of this "Will be read back as DECIMAL" behaviour!