Hi,

I use Visual Studio's COM library Oracle InProc Server 3.0 and oracle 8.1 but I can not get sdo element info:

string sql = "SELECT * FROM GEOMTABLE WHERE ROWNUM <=5";
object obj = new object();
object index = new object();
int dType = 0;
bool err = false;
string value = "";
int size = 0;

OracleInProcServer.OraSession oraDBSession = (OracleInProcServer.OraSession)new OracleInProcServer.OraSessionClassClass();
OracleInProcServer.OraDatabase oraDB = (OracleInProcServer.OraDatabase)oraDBSession.get_OpenDatabase(this.dbName, this.userInfo, 0);
OracleInProcServer.OraDynaset dynSet = (OracleInProcServer.OraDynaset)oraDB.get_CreateDynaset(sql, 0, ref obj);
OracleInProcServer.OraObject oraObj;
OracleInProcServer.OraFields oraFs;
OracleInProcServer.OraField oraF;

while (!dynSet.EOF)
{
oraFs = (OracleInProcServer.OraFields)dynSet.Fields;
oraF = (OracleInProcServer.OraField) oraFs ["GEOM_COLUMN"];
oraObj = (OracleInProcServer.OraObject)oraF.Value;
...

dynSet.MoveNext();
}

I could get all data types (numeric, varchar ...) by this C# code however I could not get sdo_geometry type(in the example: GEOM_COLUMN).
How can I get sdo element info from oraObj?

Lots of Greetings!
Ahmad