Opening Oracle view ALL_TAB_COLUMNS via SDE in ArcObjects

Discussion created by livingpj on Aug 26, 2011

I am trying to open the Oracle 11g system view SYS.ALL_TAB_COLUMNS using SDE from an ArcObjects add-in for ArcMap 10.0 in C# so I can select rows from it via a cursor.

The line of code I am using to open the table is:

  ITable table = (ITable)((IFeatureWorkspace)_workspace).OpenTable("SYS.ALL_TAB_COLUMNS");

...but this throws the following error:

  "Invalid column data type"

Not very informative I know but does anyone know how I can work around this?

I can open other views and tables such as 'SYS.USER_ROLE_PRIVS' and user tables. It may be because ArcObjects does not like the 'raw' Oracle datatypes used in this view but I don't know.

Thanks in advance