Hi there,
I'm copying a table to other table in different oracle database. When the copy finishes, I need update a state field in source table (reader). How a reader could be transformed to a writer?
Solved
How to update state machine
Best answer by mark2atsafe
As @david_r says, you could use a FeatureWriter transformer instead of a writer, then - as @arnovananrooij mentions - add a SQLExecutor to carry out an update.
The other solution is to use the writer parameter called SQL to Run After Write. You can put your SQL in there and it will run after the writer is complete.
To be honest, the FeatureWriter/SQLExecutor is a better way, because if the writer fails for some reason, you can choose not to run the SQL, but can alert an administrator instead (say with an Emailer transformer).
+5- Contributor
You could use a sqlexecuter transformer to execute statements on any database
+43- Safer
- Best Answer
As @david_r says, you could use a FeatureWriter transformer instead of a writer, then - as @arnovananrooij mentions - add a SQLExecutor to carry out an update.
The other solution is to use the writer parameter called SQL to Run After Write. You can put your SQL in there and it will run after the writer is complete.
To be honest, the FeatureWriter/SQLExecutor is a better way, because if the writer fails for some reason, you can choose not to run the SQL, but can alert an administrator instead (say with an Emailer transformer).
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.