force trigger on update when nothing changes
Posted by:
Jamie Bohr
Date: October 02, 2006 05:37PM
I have a table (local_table) that I syncronize data from another NON-MySQL DB. I have a column that I added named flag. There is function that takes inputs and returns to value that flag should be set to. For inserts and updates there is a trigger that runs and sets flag accordingly. When I have updates where no data changes because no data has changed in the remote DB, flag does not change.
The problem boils down to how do I force the trigger to update the row when no other data has changed except the flag returned by the trigger. I have over 10,000 rows to update.
Thank you for you help.
Subject
Views
Written By
Posted
force trigger on update when nothing changes
3030
October 02, 2006 05:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.