topic Re: Wrong Data Type in ArcMap Oracle connection in Data Management Questions

Wrong Data Type in ArcMap Oracle connection

OlegMueller — Fri, 25 Jul 2014 12:04:41 GMT

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

Re: Wrong Data Type in ArcMap Oracle connection

VinceAngelo — Fri, 25 Jul 2014 14:09:24 GMT

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

Re: Wrong Data Type in ArcMap Oracle connection

OlegMueller — Mon, 28 Jul 2014 08:10:36 GMT

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

Thank you a lot,

Oleg