Data change in (insert)trigger; not able to update anymore

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 39
Joined: Thu 13 Aug 2009 21:22

Data change in (insert)trigger; not able to update anymore

Post by afva » Thu 13 Aug 2009 21:42


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

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 14 Aug 2009 12:50

Do you have the IsVersion attribute set to true for your date fields?
I think you are talking about LINQ to Oracle project, please correct me if I am wrong.

Post Reply