Hi,
I must update a Oracle table. I use this parameters on the Writer:
Create Table: No
Truncate Existing Table:Yes
Writer Mode: INSERT
But the table is not updated. Can you help me?
Solved
Writer
+1- Contributor
Best answer by david_r
If you don't want the reader to consider the sheet name, use a single merged feature type when creating the reader:
If needed, you'll get the sheet name in "fme_feature_type".
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.
+1- Contributor
I don't receive errors. The log said:
Total Features Read 1026820Features Written SummaryTotal Features Written 0Translation was SUCCESSFUL with 3 warning(s) (0 feature(s) output)
I don't receive errors. The log said:
Total Features Read 1026820Features Written SummaryTotal Features Written 0Translation was SUCCESSFUL with 3 warning(s) (0 feature(s) output)
What does the number on the connection to the writer say? Is there a number at all?
Just be aware that if no features hits the writer, the target table will not be truncated.
+1- Contributor
What does the number on the connection to the writer say? Is there a number at all?
Just be aware that if no features hits the writer, the target table will not be truncated.
Can I insert an option that don't consider the sheet name?
- Best Answer
If you don't want the reader to consider the sheet name, use a single merged feature type when creating the reader:
If needed, you'll get the sheet name in "fme_feature_type".
+1- Contributor
If you don't want the reader to consider the sheet name, use a single merged feature type when creating the reader:
If needed, you'll get the sheet name in "fme_feature_type".