sbasu wrote:Check this link..
I have a form and I am trying to save it using the save button I created which insert or updates multiple records at once. I have disabled the save button.
When I save it, gives me an error ORA-01779: cannot modify a column which maps to a non key-preserved table
Even after the error it proceeds and inserts the data in the table. I get that error only when I try to use commit in the procedure.
I know this error has to do with the view and tables. The table I created is key-presereved table it has all the primary, unique and indexes required.