Page 1 of 1

error ORA-01779 while updating

Posted: Sat 19 Oct 2019 01:29
by urbanr
Hello,
When SaveChanges() is called getting ORA - 01779 cannot modify a column which maps to a non key-preserved table
error, any idea what's Is causing this?

Re: error ORA-01779 while updating

Posted: Sat 19 Oct 2019 16:39
by Shalex
Please enable dbMonitor and check the generated SQL statement. It should help to localize the problem. The cases when "ORA-01779: cannot modify a column which maps to a non key-preserved table" occurs:
* https://stackoverflow.com/questions/170 ... rved-table
* https://asktom.oracle.com/pls/asktom/f? ... 0346825287

Send us a small test project with the corresponding DDL/DML script so that we can reproduce and investigate the issue.

Re: error ORA-01779 while updating

Posted: Thu 31 Oct 2019 00:54
by urbanr
thanks for tip and link, they helped find the reason
as well very handy dbmonitor.