I am having trouble getting Arc to recognize an Oracle table attribute <NUMBER(5)> as a short integer.
We are using an Oracle Enterprise Geodatabase - the issue occurs whenever we have tables created outside of ArcGIS. The ESRI documentation (ArcGIS Help (10.2, 10.2.1, and 10.2.2) ) specifies the the Oracle datatype as NUMBER(n), where n = [1..5]. When created within Arc, the short int maps to NUMBER(5) in Oracle; however, when a table is created with NUMBER(5) directly in Oracle, Arc reads the attribute as a LONG (which is problematic primarily because domain values then get all messed up).
Is there a way to get Arc to correctly recognize the NUMBER(5) attribute as a SHORT (i.e.: maybe add a constraint to restrict values to the correct range, etc.). This needs to be done from the Oracle side without interaction with Arc. It seems like we're possibly missing some additional metadata that Arc puts somewhere to identify the NUMBER(5) as a short rather than a long.
Any help is greatly appreciated.