Skip to main content
Question

Oracel write does not recognize geometry from a wfs reader

  • Oct 20, 2026 9:53 AM UTC
  • 2 replies
  • 75 views

fme_hans
Contributor
Forum|alt.badge.img+6
Hi,Regarding FME 2026.3.I have a WFS reader that retrieves geometric data. When I attempt to save this to Oracle, the geometry is not being saved, although the attribute (non-geometric) data is.In the writer, if I set the schema definition to "Manual" under the "User Attributes" tab, the name of the geometry field is highlighted in red—indicating that it is not being recognized. It appears that the Oracle writer fails to recognize the geometry (the same applies to the Oracle Feature Writer). With the GeometryNameSetter the goemetry is found but the geoemtry type is not found.If I save the data as a Shapefile or a GeoPackage, the geometry is recognized correctly.if I perform the exact same process in FME 2025.2, the Oracle writer successfully writes the geometry. It seems that the Oracle writer has been modified in version 2026.3. (or some 2026.x version before) and does not recognize wfs geometry.

How can I ensure that the Oracle writer recognizes the geometry?

2 replies

pierrekoelich
Safer
Forum|alt.badge.img+7

Hi ​@fme_hans,

Thank you for reporting this. I have filed this internally as FMEENGINE-100106. This is definitely not expected, as in automatic feature type definition the writer should automatically set a geometry name for all outgoing features.

As for a workaround, in my testing adding a GeometryNameSetter to set the outgoing geometry name and configuring the writer feature type to have the same one will work, both when using Automatic and Manual feature type definition. In this case I use the transformer to set All geometry names to: GEOMETRY, to match with the automatic feature type definitions.

If you had it set to manual, you could set another name in the GeometryNameSetter(for example GEOM) and then on the writer Geometry Definition set it to match that name you set(GEOM again), if the arrow next to it turns green

Please let me know if you have any more questions.

Pierre


fme_hans
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • Oct 27, 2026 10:04 AM UTC

Thanks.