0 Replies Latest reply: Nov 10, 2009 6:40 AM by 733302 RSS

    Oracle InProc Server Sdo_Geometry Problem

    733302
      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!
      Johnson