OraFAQ Forum: Forms » ora-01779: can't modify a column which maps to nonkeypreserved. when i am inserting.

Home » Developer & Programmer » Forms » ora-01779: can't modify a column which maps to nonkeypreserved. when i am inserting.

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

ora-01779: can't modify a column which maps to nonkeypreserved. when i am inserting. [message #290972]

Wed, 02 January 2008 07:17

sgona
Messages: 5
Registered: December 2007
Location: pune

Junior Member

Hi,

I created ap_invoice form using ap_invoices_v& ap_invoice_distributions_v. when i am inserting i am getting error like

ora-01779: can't modify a column which maps to nonkeypreserved.

we cann't insert the data directly into view.we use generally INSTEAD OF trigger. But In forms what we have to do. please help me.

Report message to a moderator

Re: ora-01779: can't modify a column which maps to nonkeypreserved. when i am inserting. [message #290976 is a reply to message #290972]

Wed, 02 January 2008 07:46

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Quote:

we cann't insert the data directly into view.we use generally INSTEAD OF trigger. But In forms what we have to do

These are complex views and having joins with hell out of tables. I don't think you can do an insert without having INSTEAD OF trigger.

In forms you can use ON-INSERT trigger.

By
Vamsi

Report message to a moderator

Previous Topic:	Query Mutlitple Entries
Next Topic:	problem with inserting through forms in oracle apps (template.fmb)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 10:13:33 CST 2025