This discussion is archived
1 Reply Latest reply: Apr 18, 2012 12:47 PM by HamidHelal RSS

Error while inserting in the table

929642 Newbie
Currently Being Moderated
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.

Thank you

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points