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.