Exception for ORACLE DATATYPE SDO_GEOMETRY

David Travis · Post by **David Travis** » Thu 15 Oct 2009 00:34

Hi,

I get the following error when I have ORACLE DATATYPE SDO_GEOMETRY in my datacontext. Anyone have any suggestions other than to delete all the generated code for that attribute?

Invalid datatype: SDO_GEOMETRY
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Invalid datatype: SDO_GEOMETRY

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Invalid datatype: SDO_GEOMETRY]
Devart.Data.Oracle.Linq.Provider.a.a(String A_0, Boolean A_1) +579
Devart.Data.Oracle.Linq.Provider.a.a(String A_0) +55
Devart.Data.Linq.Provider.TypeSystemProvider.GetProviderType(String typeName) +165
Devart.Data.Linq.Provider.Query.SqlFactory.Default(MetaDataMember member) +237
Devart.Data.Linq.Provider.Query.SqlFactory.a(SqlExpression A_0, MetaDataMember A_1) +48
Devart.Data.Linq.Provider.Query.ar.a(d A_0, MetaType A_1, List`1& A_2, List`1& A_3, SqlExpression& A_4, IList`1 A_5) +1166
Devart.Data.Linq.Provider.Query.ar.b(d A_0, MetaType A_1, List`1& A_2, List`1& A_3, SqlExpression& A_4, IList`1 A_5) +86
Devart.Data.Linq.Provider.Query.ar.a(d A_0, IList`1 A_1) +246
Devart.Data.Linq.Provider.Query.ar.a(MetaType A_0, ITable A_1, IList`1 A_2) +221
Devart.Data.Linq.Provider.Query.ar.a(MetaType A_0, ITable A_1) +42
Devart.Data.Linq.Provider.Query.ar.a(bh A_0) +682
Devart.Data.Linq.h.a(bh A_0, List`1 A_1) +350
Devart.Data.Linq.h.a(MetaDataMember A_0, bh A_1, List`1 A_2) +122
Devart.Data.Linq.Provider.b.a(q A_0) +3402
Devart.Data.Linq.Provider.b.a(SqlExpression A_0) +1322
Devart.Data.Linq.Provider.b.b(SqlExpression A_0) +52
Devart.Data.Linq.Provider.g.a(f A_0, SqlExpression A_1) +81
Devart.Data.Linq.Provider.g.a(Type A_0, SqlExpression A_1, f A_2, p A_3) +67
Devart.Data.Linq.Provider.c.a(Int32 A_0) +696
Devart.Data.Linq.Provider.DataProvider.a(c A_0, f A_1, IDbConnection A_2, IDataReader A_3) +429
Devart.Data.Linq.Provider.DataProvider.a(c A_0, f A_1, Object[] A_2, Object[] A_3, Object A_4) +1656
Devart.Data.Linq.Provider.DataProvider.a(c A_0, Object[] A_1) +137
Devart.Data.Linq.Provider.DataProvider.h(Expression A_0) +191
Devart.Data.Linq.DataQuery`1.i() +53
System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +7665318
System.Linq.Enumerable.ToList(IEnumerable`1 source) +61

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +71
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +261
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
System.Web.UI.WebControls.LinqDataSourceView.ToList(IQueryable query, Type dataObjectType) +126
System.Web.UI.WebControls.LinqDataSourceView.ExecuteSelectQuery(LinqDataSourceSelectEventArgs selectEventArgs, Object selectResult, Object table, Boolean storeOriginalValues) +327
System.Web.UI.WebControls.LinqDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +457
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +19
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +72
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +44
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

AndreyR · Post by **AndreyR** » Thu 15 Oct 2009 09:22

Object types (particularly SDO_GEOMETRY) are currently not supported in our LINQ to Oracle implementation.
We will investigate the possibility of adding this kind of support, but no timeframe is available.

Emily · Post by **Emily** » Mon 28 Dec 2009 23:21

Devart,

My organization is heavily invested using SDO_GEOMETRY and such spatial data. Any plans for Devart to have this implemented. Me work for big organization, so very important when considering dotConnect.

AndreyR · Post by **AndreyR** » Tue 29 Dec 2009 12:42

We plan to add the support for the Object types, but no timeframe is available.