update row fails with error ORA-01779
Posted: Mon Oct 22, 2018 2:05 pm
Hello,
I've set a sql-string as a writebacktable that selects from different db tables.
Now I am trying to update a row and I get the error:
ORA-01779: cannot modify a column which maps to a non key-preserved table
How can I achieve an update in this case?
Thank you.
Regards,
Julia
I've set a sql-string as a writebacktable that selects from different db tables.
Now I am trying to update a row and I get the error:
ORA-01779: cannot modify a column which maps to a non key-preserved table
How can I achieve an update in this case?
Thank you.
Regards,
Julia