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.
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.