Message FRM-40600: Record has already been inserted. |
Cause of Error This behavior occurs when you try to insert a record that already exists in the database or that has the same primary key value as an existing record and the primary key constraint is enabled. |
Solution Summary If this is a duplicate record, do not insert it into the database. If the primary key value is not unique, make the value unique. Or, if you must have duplicate values for the current primary key, consider changing the primary key or removing the primary key constraint. |
Solution Details 1) If this is a duplicate record, do not insert it into the database.  NOTE: You can query the database by using the form to see if the record is a duplicate. 2) If the primary key value is not unique, do one of the following: a) In the appropriate field, change the value to a unique value. b) If you must have duplicate values in the current primary key field or fields, consider changing the primary key or removing the primary key constraint. CAUTION: Changing a primary key or removing a primary key constraint from a table may affect data in the table. Be sure to review the table design and understand why the field or fields were selected to be the primary key before you proceed. |
Applies to Software Version Oracle8 |
Error: FRM-40600: Record has already been inserted (in Developer 6.0 Forms).
