OraFAQ Forum: Forms » Unable to Insert record In forms: error -ORA-01779 :cannot modify a column

Home » Developer & Programmer » Forms » Unable to Insert record In forms: error -ORA-01779 :cannot modify a column (Oracle Apps)

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

Unable to Insert record In forms: error -ORA-01779 :cannot modify a column [message #393966]

Wed, 25 March 2009 04:06

subirdutta
Messages: 7
Registered: September 2008
Location: Pune

Junior Member

Hi,
I have created one form with two block.
Block-1 : Based on View
Block-2 : Based on table

There is is relationship between Block-1 and Block-2.
Block-1 is populating from LOV.
I just need to insert /update record Block-2 based on data from Block-1
So Block-1 I have made read only at runtime (Inser/update all properties are false).

Now when I insert record in Block-2 based on record from block-1, and getting below error.
"ORA-01779: cannot modify a column which maps to a non key-preserved table"

It is not allowing to insert record.

Please help me.

Subir

Attachment: Error.JPG
(Size: 69.18KB, Downloaded 559 times)

Report message to a moderator

Re: Unable to Insert record In forms: error -ORA-01779 :cannot modify a column [message #394002 is a reply to message #393966]

Wed, 25 March 2009 05:35

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

You've got some code that's modifying block one.

You can only get that error from trying to do DML on views.

When you say you're populating block1 from an LOV what exactly do you mean?

Report message to a moderator

Re: Unable to Insert record In forms: error -ORA-01779 :cannot modify a column [message #394010 is a reply to message #394002]

Wed, 25 March 2009 06:08

subirdutta
Messages: 7
Registered: September 2008
Location: Pune

Junior Member

Just like master detail relation.
From LOV populating one record in the 1st block, the based on that record inserting record on 2nd block.

Report message to a moderator

Re: Unable to Insert record In forms: error -ORA-01779 :cannot modify a column [message #394015 is a reply to message #393966]

Wed, 25 March 2009 06:23

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

That really doesn't answer my question.

Are you using forms default query behaviour or are you manually populating the block from a cursor/procedure or something else?

Report message to a moderator

Previous Topic:	Disabling a button
Next Topic:	How to assign a value to text item in particular format.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 11:17:28 CST 2025