arcMap: DBA number field types show 0
Posted on 2015-01-15
I am a new ArcMap and have a formatting issue. I am using ArcMap 10 and Oracle 10g. Here is my issue:
My table "Hub_Tickets" in oracle has a field called "Impact_Score" that is a number format. When I add this table to a ArcMap session, I go to "Open" and find the field and it shows that it's a "Long" character. Here is the issue, when I review the records it shows 0, and not the real values "1 through 5,000,000". This isn't the only field it does this to. It only changes number format field values.
I tried changing the format in Oracle to text and it works, the numbers are displayed but that are text so I can't use the symbology to make ranges for color changes.
I also tried in the Catalog -->table properties --> Fields tab, and change the data type. I get error of Unable to alter the field's type ORA-00942: Table or view does not exist.
Any idea what I should do?
**UPDATE** I did have come across another table that has values showing that are long types. The difference I see is that the "precision" has a number 10. Where as my field doesn't have that precision listed. Any ideas?
I had to format the field like this. Any reason why? I have many other fields and it seems that it would be a lot of time to do so. Using views.. too
CAST(MHI.IMPACT_SCORE AS NUMBER(10)