Send data loaded from oracle table - how to mark sucessfully sent rows?
963952Oct 2 2012 — edited Oct 3 2012Hello,
I have one oracle database table, set as source. Data from table are loaded row by row and inserted to other table, file or csv (it does not matter). I need to perform update for each row in source table to mark data is already sent, if current row is sent witout any errrors. For example, there is IS_SENT field in my source table - it should be set to TRUE if row is succesfully inserted to target table and to FALSE otherwise.
What is the simplest way to do this? Can I put sql script to my interface to update field for each row, that will be executed after row is succesfully inserted to destination table?