Problem: ArcIMS displays some ArcSDE /Oracle 9i feature class values with scientific notation
ArcIMS displays some feature class values with scientific notation when using ArcSDE for Oracle 9i if a field defined as NUMBER without length is added to an existing feature class in Oracle's SQLPLUS.
For example :
ALTER TABLE route_hwy ADD (ROUTE_A NUMBER);
Insert the values into ROUTE_A and commit to the database.
When performing an identify in ArcMap the ROUTE_A value appears correctly, for example: 1 or 29 or 100. However, when performing an identify or query with ArcIMS; for example, with Author, the values returned appear as 1E0 or 29E1 or 1E2.
This problem does not exist when using ArcIMS 4.0.1 with ArcSDE 8.3 for Oracle 8i.
At Oracle 9i, a field defined as NUMBER without length is converted with incorrect precision definitions by ArcIMS.
Solution or Workaround
Follow the steps below.
- Do not create a field with NUMBER without length. Specify a length.
- If the column already exists, Export the feature class to shapefile and then Export it back into a Geodatabase feature class. The process adds NUMBER (28,10) to the field.