# Error by loading a Oracle Spatial Layer

**URL:** <https://community.thinkgeo.com/t/error-by-loading-a-oracle-spatial-layer/1800>\
**Category:** WinForms\
**Created:** [September 28, 2011, 1:02am UTC](https://community.thinkgeo.com/t/error-by-loading-a-oracle-spatial-layer/1800 "2011-09-28T01:02:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hans1](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/h/e68b1a/32.png) [@Hans1](https://community.thinkgeo.com/u/Hans1)\
**Post date:** [September 28, 2011, 1:02am UTC](https://community.thinkgeo.com/t/error-by-loading-a-oracle-spatial-layer/1800/1 "2011-09-28T01:02:20Z")

</div>

&nbsp;

I&nbsp;have&nbsp;a&nbsp;problem&nbsp;when&nbsp;opening&nbsp;an&nbsp;Oracle&nbsp;Spatial&nbsp;layer.&nbsp;I&nbsp;use&nbsp;Oracle&nbsp;Spatial&nbsp;10g,&nbsp;and&nbsp;get&nbsp;the&nbsp;following&nbsp;error:  
  
  
  
ORA-13199:&nbsp;3D&nbsp;geometries&nbsp;are&nbsp;not&nbsp;supported&nbsp;by&nbsp;geometry&nbsp;WKB&nbsp;/&nbsp;WKT&nbsp;generation.  
  
ORA-06512:&nbsp;at&nbsp;"MDSYS.MD",&nbsp;line&nbsp;1723  
  
ORA-06512:&nbsp;at&nbsp;"MDSYS.MDERR",&nbsp;line&nbsp;17  
  
ORA-06512:&nbsp;at&nbsp;"MDSYS.SDO\_UTIL",&nbsp;line&nbsp;2415  
  
ORA-06512:&nbsp;at&nbsp;"MDSYS.SDO\_GEOMETRY",&nbsp;line&nbsp;30  
  
  
  
Now&nbsp;it&nbsp;may&nbsp;be&nbsp;me;&nbsp;but&nbsp;I'm&nbsp;sure&nbsp;that&nbsp;the&nbsp;data&nbsp;is&nbsp;not&nbsp;3D.&nbsp;TatukGIS&nbsp;(we&nbsp;use&nbsp;it&nbsp;now)&nbsp;works&nbsp;fine.

The&nbsp;code&nbsp;below&nbsp;is&nbsp;what&nbsp;I've&nbsp;tried&nbsp;(the&nbsp;geometry&nbsp;is&nbsp;of&nbsp;type&nbsp;point):  
  
  
  
`    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click        WinformsMap1.MapUnit = GeographyUnit.Meter        WinformsMap1.BackgroundOverlay.BackgroundBrush = New GeoSolidBrush(GeoColor.GeographicColors.ShallowOcean)        Dim connectString As String = "User ID=testgv1;Password=test123;Data Source=DQ-OR:1521/LDORP;"        Dim oracleLayer As New OracleFeatureLayer(connectString, "GBI_BOOM", "BOOM_ID")        Dim proj4Projection As New Proj4Projection()        proj4Projection.InternalProjectionParametersString = proj4Projection.GetEpsgParametersString(28992)        proj4Projection.ExternalProjectionParametersString = proj4Projection.GetEpsgParametersString(28992)        oracleLayer.FeatureSource.Projection = proj4Projection        oracleLayer.ZoomLevelSet.ZoomLevel01.DefaultPointStyle = PointStyles.Capital1        oracleLayer.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel = ApplyUntilZoomLevel.Level20        oracleLayer.Open()        Dim staticOverlay As New LayerOverlay()        staticOverlay.Layers.Add("BOMEN", oracleLayer)        WinformsMap1.Overlays.Add(staticOverlay)        WinformsMap1.CurrentExtent = oracleLayer.GetBoundingBox        WinformsMap1.Refresh()    End Sub`

---

<div class="post-metadata">

**Author:** ![Hans1](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/h/e68b1a/32.png) [@Hans1](https://community.thinkgeo.com/u/Hans1)\
**Post date:** [September 29, 2011, 3:57am UTC](https://community.thinkgeo.com/t/error-by-loading-a-oracle-spatial-layer/1800/2 "2011-09-29T03:57:28Z")

</div>

Is&nbsp;my&nbsp;problem&nbsp;too&nbsp;difficult?

---

<div class="post-metadata">

**Author:** ![Ethan](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/ethan/32/19964_2.png) [@Ethan](https://community.thinkgeo.com/u/Ethan)\
**Post date:** [September 29, 2011, 11:08am UTC](https://community.thinkgeo.com/t/error-by-loading-a-oracle-spatial-layer/1800/3 "2011-09-29T11:08:01Z")

</div>

Hi&nbsp;Hans,&nbsp;  
&nbsp;&nbsp;  
&nbsp;Sorry&nbsp;we&nbsp;cannot&nbsp;reproduce&nbsp;that.&nbsp;  
&nbsp;&nbsp;  
&nbsp;This&nbsp;exception&nbsp;should&nbsp;thrown&nbsp;by&nbsp;Oracle&nbsp;or&nbsp;NTS,&nbsp;we&nbsp;don’t&nbsp;have&nbsp;this&nbsp;exception&nbsp;related&nbsp;code.&nbsp;&nbsp;  
&nbsp;&nbsp;  
&nbsp;I&nbsp;google&nbsp;and&nbsp;found&nbsp;someone&nbsp;get&nbsp;same&nbsp;exception:&nbsp;[kr.forums.oracle.com/forums/thread.jspa?messageID=3708662](http://kr.forums.oracle.com/forums/thread.jspa?messageID=3708662)&nbsp;  
&nbsp;&nbsp;  
&nbsp;Here&nbsp;we&nbsp;have&nbsp;another&nbsp;topic&nbsp;related&nbsp;with&nbsp;this:&nbsp;[gis.thinkgeo.com/Support/DiscussionForums/tabid/143/aff/12/afv/topic/aft/6836/Default.aspx](http://gis.thinkgeo.com/Support/DiscussionForums/tabid/143/aff/12/afv/topic/aft/6836/Default.aspx)&nbsp;  
&nbsp;&nbsp;  
&nbsp;I&nbsp;am&nbsp;not&nbsp;sure&nbsp;whether&nbsp;that’s&nbsp;helpful,&nbsp;but&nbsp;I&nbsp;think&nbsp;maybe&nbsp;you&nbsp;can&nbsp;try&nbsp;to&nbsp;build&nbsp;some&nbsp;very&nbsp;simple&nbsp;data&nbsp;and&nbsp;try&nbsp;again&nbsp;for&nbsp;make&nbsp;sure&nbsp;whether&nbsp;that’s&nbsp;thrown&nbsp;by&nbsp;database&nbsp;and&nbsp;we&nbsp;can&nbsp;make&nbsp;sure&nbsp;the&nbsp;research&nbsp;direction.&nbsp;  
&nbsp;&nbsp;  
&nbsp;Regards,&nbsp;  
&nbsp;&nbsp;  
&nbsp;Don