span8
span4
span8
span4
In Oracle,i have a column called GEOM of SDO_GEOMETRY type.After running FME,GEOM column containing NULL values it is not getting populated.Could you please help me?
Oops,Yes,Before the below steps place an inspector and check whether geometry is the translation result or not at before and after SQLExecutor,If geometry is the result then...
Below are the steps while creating writer and hope you have already placed it correctly...
1.Check whether the writer you have used is "Oracle Spatial Object"
2.While defining the writer,have you specified the Geometry Column as GEOM
Based on Geometry
3.Check the type of geometry it is passing to writer (i.e.line/point)
4.Define "oracle_type" with an attribute creator
As you are using a SQLExecutor FME will add a format attribute oracle_geometry containing no_geom as a value.When writing to Oracle FME will use this format attribute.Removing the format attribute using the BulkAttributeRemover with parameter oracle* will force FME to use the fme attribute fme_geometry that contains the correct geometry type.
Since you are extracting the attribute then I hope you are using Format as "Oracle Non-spatial" so use the "Initiator" port instead of "Result" port as well as in "Combine Attributes" option select "Keep Initiator Attributes if conflict" as you are extracting new attribute,this option will not affect any new extracted attributes
Hi,
If you are adding attributes with SQLExecutor then consider the "Initiator" port instead of result.
If you are adding geometry with SQLExecutor then review the options you have selected in SQL Executor.
Pratap
Using Oracle Spatial instead of ESRI sde geodatabase writer?5 Answers
Oracle Sql Query from Oracle Database to extract data3 Answers
Oracle db connection to FME6 Answers
Oracle Spatial to SHAPE1 Answer
SHP to Oracle Database5 Answers
© 2019 亚搏在线Safe Software Inc |Legal