Hi
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
Paul
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
Paul