Wrong Data Type in ArcMap Oracle connection

484
2
07-25-2014 05:04 AM
OlegMueller
New Contributor

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

Tags (1)
0 Kudos
2 Replies
VinceAngelo
Esri Esteemed Contributor

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

0 Kudos
OlegMueller
New Contributor

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

Thank you a lot,

Oleg

0 Kudos