Support for advanced datatypes (Spatial, XMLType, JSON) with Managed Driver

Andreas Weiden

Hi,

were using the Oracle database especially for the advanced features in the spatial areas. In the last years, other interchangeable dataformats like XMLTYPE and Json become more and more important also for us.

On the other side our client-software changes more and more to C#. We're using the Unmanaged-driver at the moment and are able to deal with Sptail by using the UDT-features at the moment. But sooner or later we will be forced to go forward to use the managed-driver, which does not seem to develop forward to support any of the mentioned datatypes.

Are there any plans to change this in the near future (and i mean near future, i asked the question about Spatial several years ago and nothing happend til now).?

Alex Keh-Oracle

Unfortunately, not in the near future. Porting UDTs to 100% managed code is a very big task.

Other ODP.NET Spatial customers have used well-known text to make the jump from unmanaged to managed ODP.NET.

Andreas Weiden

Ok, but even if something is a very big task it needs to be done either at some point in time. Otherwise you will loose the strength of your product in my opinion.

And about WKT... That might work with small and few geometries. We have geometries with more than 100.000 vertices. That doesn't work for us. And we have business objects which consist of about 1000 records with such geometries. So even if it would work technically, it would be a performance nightmare.