Skip to main content
Archived

No altering of geometry when using the Oracle Non-Spatial writer

Related products:Integrations
  • June 14, 2017
  • 2 replies
  • 47 views

bradr
Contributor
Forum|alt.badge.img+9

When I update columns with the Oracle Non-Spatial writer on a Oracle table which contains a Geometry column that geometry is altert. The column is not listed in the 'User attributes' tab of the writer (Geometry never appears there) and on the 'Format Parameters'-tab there are no references to geometry. Despite of using the non-spatial writer it still writes or removes the geometry.

I am aware of the Oracle Spatial Writer option 'Update Spatial Colum(s)' to prevent so.

Advice: do not alter spatial column with the Oracle Non-Spatial writer

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

Forum|alt.badge.img+2
  • June 16, 2017

Would need to make that really clear to stop any regression by others actually using that feature.

Recently came across an issue using DatabaseUpdater where FME 2015 only updated attributes (what I wanted), but running same workspace in FME 2016 actually modified the geometry as well which my customer wasn't happy about.


erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • June 16, 2017

Agree with @mark_1spatial: Changing this could hurt existing processes that rely on this behavior.

I would suggest adding an option to remove or not remove the geometry.

But the best option is to use the Oracle Spatial Writer as mentioned.