Data change in (insert)trigger; not able to update anymore
Posted: Thu 13 Aug 2009 21:42
Hello,
I want to do as follows:
1. insert a record A in the database
2. perhaps update this same record.
Problem is that in Oracle I have a trigger (before insert) that truncates all of my date-fields before he puts them in the database.
That works o.k., until the customers changes record A again and wants to submit these changes to the database again.
I get th error: Row not found or changed.
I understand why this is; but I am curious to know how to avoid this.
Thanks in advance
I want to do as follows:
1. insert a record A in the database
2. perhaps update this same record.
Problem is that in Oracle I have a trigger (before insert) that truncates all of my date-fields before he puts them in the database.
That works o.k., until the customers changes record A again and wants to submit these changes to the database again.
I get th error: Row not found or changed.
I understand why this is; but I am curious to know how to avoid this.
Thanks in advance