TomBarrand
Programmer
Hi,
I am trying to update a column with a view using the SQL statement below, but get the following error.
UPDATE TEST.VIEW_USR SET STRKNOWNAS = 'joe.bloggs@asasa.com WHERE PK_LNGPERSONIDCNT = 12993;
ORA-01779: cannot modify a column which maps to a non key-preserved table
Any advise would be much appreciated.
Thanks
I am trying to update a column with a view using the SQL statement below, but get the following error.
UPDATE TEST.VIEW_USR SET STRKNOWNAS = 'joe.bloggs@asasa.com WHERE PK_LNGPERSONIDCNT = 12993;
ORA-01779: cannot modify a column which maps to a non key-preserved table
Any advise would be much appreciated.
Thanks