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".
+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)
maica wrote:
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
david_r wrote:
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
david_r wrote:
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".
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.