rtrevino

esriFieldTypeDouble Max Value in SDE?

Discussion created by rtrevino on Aug 10, 2010
Latest reply on Aug 13, 2010 by rtrevino
Greetings,
I am converting an In-Memory feature class to SDE, but am having an issue.
If I have a column defined as esriFieldTypeDouble, and the value in that column is 1.000000e+037, then saving to an oracle SDE instance fails when attempting a
featureDataConverter.ConvertFeatureClass(inFCName, null, null, outFCName, targetGeometryDef, pFixedFlds, null, 100, 0);
The error I get is:
DBMS table not found[ORA-00942: table or view does not exist][SDEServer.fclassname][STATE_ID = 167]

This seems to only happen when the values in the double column are large, as above.  If I edit the value in that column to be a number such as 123.45, it saves without issue.
Is there something special I need to be doing when defining the column?  I've tried setting the precision and scale for the esriFieldTypeDouble column to many different combinations, but nothing seems to work.

Thanks for any help!
-Robert

Outcomes