Hello
I am attempting to make non spatial Oracle table data spatial, I have created the FME workbench no problem but when it comes to writing the results to an Oracle table using Oracle Spatial table no points are displayed just the data.
Basically I am missing the accompanying spatial data to the points.
I am sorry if my post makes no sense and please ask any further questions.
Many thanks
Sy
Can you show us how the writer was configured? Some screenshots or a copy of the workspace (simplified, if necessary) would be helpful.
Do you have attributes containing coordinates in your non-spatial table? If so you will need to create your points using these values with a vertexcreator
Hi, I've added a copy of the writer and in the translation log it cannot write any spatial data due to lack of a spatial column. Capture.PNG
The points are created using the VertexCreator.
Try changing the table handling to drop and create rather than truncate
ebygomm - that has worked, thank you very much - something so simple!