Oracle Numeric(38) is mapped to 4-bit Long Integer in ArcGIS 9.1 and 9.2.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM005651
Submitted
December 15, 2006
Last Modified
April 28, 2025
Applies to
No Product Found
Version found
9.2
Status
Will Not Be Addressed
The development team has considered the issue or request and concluded it will not be addressed. The issue's Additional Information section may contain further explanation.
Additional Information
No Public Explanation
Workaround
ArcSDE supports 32 bit integers. The number(38) maps to longInt with the geodatase (4 byte = 32 bits).The largest 32 bit number is 2147483648 which is 10 digits so this is by design until we support 64-bit Objectids (in future releases).Incident #538294:User found a problem when trying to convert a field defined in Oracle as number(38) to OBJECTID. Basically, ArcSDE (till 9.2) can only use 10 digits to store a interger as OBJECTID column.#NIM005651 submitted.