I have a database connection to one of our Oracle server. The problem is, that ArcMap shows the wrong data type for different ID fields in the table I wanted to use. If I connect to the database with Oracle SQL Developer the data type is correctly shown as "NUMBER", in ArcMap it is "Double". How can I fix this?
ArcGIS uses ANSI standard types. NUMBER is something else, which when bound to a variable, maps closest to 'double'. In order to map to integer (32-bit) in ArcGIS, the NUMBER must be either NUMBER(38) or NUMBER(10) - NUMBER(5). 16-bit "short" integers start at NUMBER(4).