Home » Developer & Programmer » Forms » ora-01779: can't modify a column which maps to nonkeypreserved. when i am inserting.
ora-01779: can't modify a column which maps to nonkeypreserved. when i am inserting. [message #290972] Wed, 02 January 2008 07:17 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 03 23:03:10 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.