Home » Developer & Programmer » Forms » FRM-40600 Record has already been inserted (after upgrading) (forms6i)
FRM-40600 Record has already been inserted (after upgrading) [message #426723] Mon, 19 October 2009 02:52 Go to next message
ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore
Member
Hello,

Upgraded all the forms from ORACLE FORMS5.0 to ORACLE FORMS 6i.
There is no change in logic, data, etc. only upgradation was done.

After upgradation,

When the form is run in 6i, then it pops up error message while inserting new record or updating a record.
"Frm-40600: Record has already been inserted".

When the same form is run in 5.0, no error message. Able to save and edit.

How to overcome above issue?

-Karthik

Re: FRM-40600 Record has already been inserted (after upgrading) [message #426730 is a reply to message #426723] Mon, 19 October 2009 03:25 Go to previous messageGo to next message
Littlefoot
Messages: 20824
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Strange.

Did you try to recompile ALL (<Ctrl + Shift + K>) prior to generating the form?
Re: FRM-40600 Record has already been inserted (after upgrading) [message #426735 is a reply to message #426723] Mon, 19 October 2009 04:08 Go to previous messageGo to next message
ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore
Member
Yeah, I did.
All forms are working, only few raising this issue.


For reference : http://forums.oracle.com/forums/thread.jspa?threadID=890290

I didn't understand what he is saying in the above link.

Re: FRM-40600 Record has already been inserted (after upgrading) [message #426741 is a reply to message #426735] Mon, 19 October 2009 04:38 Go to previous message
Littlefoot
Messages: 20824
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I think that he created primary key value in form (I don't know how), but when he tried to save changes, the form has said that the record already exists - primary key constraint has been violated. Once he fixed the way of creating a primary key, the error got resolved.
Previous Topic: Stacked canvas is not working (merged 4)
Next Topic: Raise form_trigger_failure
Goto Forum:
  


Current Time: Sat Sep 24 16:21:03 CDT 2016

Total time taken to generate the page: 0.64765 seconds