Oracle Database Discussions

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!

How to get an INTEGER data type in Oracle 11g?

HDuqueCSep 7 2014 — edited Oct 30 2014

Hi to all.

I'm quite new in Oracle and I need to migrate an Informix database to Oracle 11g. The Informix database has a lot of primary keys as INTEGER data type (id's).

Making some tests in Oracle with similar database structure replacing the INTEGER by NUMBER(10,0), the client application crashes because it finds a DOUBLE data type instead an INTEGER for the primary keys.

Is there any way to mask the NUMBER(10,0) data type to be shown as if it where an INTEGER type.

Regards,

Hernando.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 8 2014

Added on Sep 7 2014

#general-database-discussions

19 comments

6,333 views