OraFAQ Forum: Forms » FRM-40600 Record has already been inserted (after upgrading)

Home » Developer & Programmer » Forms » FRM-40600 Record has already been inserted (after upgrading) (forms6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-40600 Record has already been inserted (after upgrading) [message #426723]

Mon, 19 October 2009 02:52

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

Report message to a moderator

Re: FRM-40600 Record has already been inserted (after upgrading) [message #426730 is a reply to message #426723]

Mon, 19 October 2009 03:25

Littlefoot
Messages: 21818
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?

Report message to a moderator

Re: FRM-40600 Record has already been inserted (after upgrading) [message #426735 is a reply to message #426723]

Mon, 19 October 2009 04:08

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.

Report message to a moderator

Re: FRM-40600 Record has already been inserted (after upgrading) [message #426741 is a reply to message #426735]

Mon, 19 October 2009 04:38

Littlefoot
Messages: 21818
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.

Report message to a moderator

Previous Topic:	Stacked canvas is not working (merged 4)
Next Topic:	Raise form_trigger_failure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:25:45 CDT 2024