Problem With Oracle and SRID

Jul 21, 2008 at 10:06 PM
Hi,

I retrive without problems data from a oracle table, but when this table have a SRID have a error, Unknow how correct the problem....
Developer
Jul 22, 2008 at 8:25 AM
Post some code hat generates the error, because afaik srid is well managed from OracleProvider.
Jul 22, 2008 at 3:43 PM
Edited Jul 22, 2008 at 3:54 PM

is same to this error:  http://forums.oracle.com/forums/thread.jspa?threadID=218341


ORA-29902: error in executing ODCIIndexStart() routine
ORA-13208: internal error  while evaluating [window SRID does not match layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286

This is the error say in oracle, the file afected is orace.cs:

 using (OracleCommand command = new OracleCommand(strSQL, conn))
    {
     conn.Open();
     using (OracleDataReader dr = command.ExecuteReader())
     {      
      while (dr.Read())
      {
       if (dr[0] != DBNull.Value)
       {
        SharpMap.Geometries.Geometry geom = SharpMap.Converters.WellKnownBinary.GeometryFromWKB.Parse((byte[])dr[0]);                              
                                if(geom!=null)
         features.Add(geom);        
       }
      }    
     }
     conn.Close();
    }

 

Is

Jul 22, 2008 at 5:42 PM
Solve!!!!, The problem is Uppercase in Table on oracle, get the Metadata using name of table in Uppercase.

regards