topic ArcMap not giving correct values for NUMBER(38) column in Geodatabase Questions

ArcMap not giving correct values for NUMBER(38) column

Anonymous User — Mon, 19 Sep 2016 03:03:20 GMT

I have made a non-spatial table in oracle called OSH_TEST_NS which is defined in oracle as:

CREATE TABLE OSH_TEST_NS (

ID NUMBER(38,0),

RUN_ID NUMBER(38,0),

CONSTRAINT OSH_TEST_NS_PK PRIMARY KEY (ID));

--Insert 1 row:

Insert into OSH_TEST_NS (ID, RUN_ID) values (1,1);

COMMIT;

However when I view the attribute table in ArcMap it has a zero for the RUN_ID when this should be a value of 1.

Is this a bug in ArcMap?

See attached screenshot.

Re: ArcMap not giving correct values for NUMBER(38) column

JoshuaBixby — Tue, 11 Oct 2016 01:18:49 GMT

What version of ArcMap are you using? What version of Oracle? Is the Oracle database also a geodatabase or just a regular Oracle database? If you select the records from outside of ArcMap, e.g., using sqlplus, does the record look as you expect?

I just did a quick test on an ArcMap 10.3.1 machine connecting to Oracle 11.2.0.3, and the values look/are correct. I created the table outside of ArcMap (using sqlplus) following the SQL provided.