ArcMap not giving correct values for NUMBER(38) column

Anonymous User

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.

osh_test.JPG

Union_mismatch2.jpg

KathrynDoh_0-1651084183715.png

JoshuaBixby

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.

title gif.gif