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?
Question
Null values in Oracle GEOM column
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.
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.
+12- Contributor
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
@pratap in the sql executor i have used, iam just retreving a value from non_spatial table. is it the reason why iam getting null in geometry column?if it is the reason can you help me in getting out of that issue?
+12- Contributor
@gouthami
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
+26- Contributor
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.
@gouthami
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
In That Scenario, whatever the attribute iam selecting from "Oracle Non-spatial" object wont get reflected through Initiator Port.
+12- Contributor
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
+8As 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.
Thanx Erik-Jan, brilliant remark as always. Actually, it was oracle_nil. Now I replaced the value with oracle_area.