Opening Oracle view ALL_TAB_COLUMNS via SDE in ArcObjects

PaulLivingstone — Fri, 26 Aug 2011 17:56:53 GMT

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

topic Opening Oracle view ALL_TAB_COLUMNS via SDE in ArcObjects in ArcObjects SDK Questions

Opening Oracle view ALL_TAB_COLUMNS via SDE in ArcObjects