Wrong Data Type in ArcMap Oracle connection

Question

Hi,

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?

thx

OlegMueller · Answer

OK, then I will contact one of our database administrators.

Thank you a lot,

Oleg

VinceAngelo · Answer

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).

- V