Skip to main content
Question

Writing 3D Geometries to Oracle not working

  • May 14, 2025
  • 1 reply
  • 22 views

pkno
Contributor
Forum|alt.badge.img+5
  • Contributor

Hello,

I am trying to write 3D Geometries (Points and Linestrings) to an Oracle-Database (21c Express). In the process all z-Coordinates get lost and SDO_GTYPE is wrongly written as 2001 or 2002 (2-Dimensional Geometries) instead of 3001 and 3002.

Multiple Geometries are entering the writer as an aggregate (example below).
 

 

Apart from the z-Coordinate missing these are written and interpreted correctly when writing to Oracle. I have checked the “Contains Z Ordinate” Option in the Writer-Parameters.

Does anyone have anymore ideas what I could try?

1 reply

pkno
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • May 14, 2025

To answer this myself … this was solved by editing the Metadata in user_sdo_geom_metadata to explicitly contain 3D-Geometries.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings