Tuesday, February 14, 2012

Oracle arcSde view small integer bug

I am writing this here just as a reminder.

ArcSde with Oracle (11g  maybe all) has a bug where when you create a Feature layer with a small integer column and then create a view out of that table, the view will now have the column as integer.

I have not found a solution for this, except rewriting the code…


You can see it in ArcGis Server:

For SQL Server 2008 table: Type: esriFieldTypeSmallInteger

For Oracle 11g view: Type: esriFieldTypeInteger