Home » SQL & PL/SQL » SQL & PL/SQL » Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table
Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table [message #418202] Thu, 13 August 2009 07:47 Go to next message
dilipn_nitw@yahoo.com
Messages: 16
Registered: July 2009
Location: India
Junior Member

Hi Friends,

I am getting the following error message when i am running my package - pwr_rev_ins_pkg.pwr_populate_interface

Kindly advice what could be the reason for getting the following error -

Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table

Package spec and Body is uploaded for your reference.


Thanks & Regards
Ramya Nomula
Re: Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table [message #418203 is a reply to message #418202] Thu, 13 August 2009 07:49 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Without trawlingthrough 30k of code, I'd guess that you've got an update of the form:
UPDATE (<inline view>) SET ...

Re: Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table [message #418205 is a reply to message #418202] Thu, 13 August 2009 07:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://tinyurl.com/p8a2fy

Regards
Michel
Re: Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table [message #418206 is a reply to message #418203] Thu, 13 August 2009 07:54 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
This link might help

Ross Leishman
Re: Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table [message #418208 is a reply to message #418202] Thu, 13 August 2009 07:58 Go to previous messageGo to next message
dilipn_nitw@yahoo.com
Messages: 16
Registered: July 2009
Location: India
Junior Member

Thanks for all your tips,i will check the same from my side.


Thanks & Regards
Ramya Nomula
Re: Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table [message #418209 is a reply to message #418206] Thu, 13 August 2009 08:00 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Hit #4 on Google is this detailed analysis from a pillar of the ORACLE community.
./fa/6681/0/
  • Attachment: bc.GIF
    (Size: 26.91KB, Downloaded 540 times)
Re: Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table [message #418210 is a reply to message #418209] Thu, 13 August 2009 08:04 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
Another great tip from Don
Re: Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table [message #418217 is a reply to message #418209] Thu, 13 August 2009 08:27 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Quote:
Need Oracle Consulting Services?

Order now and receive a shining siver bullet in polished wooden box!
Re: Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table [message #418221 is a reply to message #418217] Thu, 13 August 2009 08:48 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
LMAO Laughing
Re: Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table [message #418227 is a reply to message #418217] Thu, 13 August 2009 08:57 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Frank wrote on Thu, 13 August 2009 14:27
Quote:
Need Oracle Consulting Services?

Order now and receive a shining siver bullet in polished wooden box!


Then shoot your db server with it and watch it explode!
Previous Topic: using UTL_FILE for bulk_exceptions
Next Topic: Select Sdo_elem_Info & Sdo_ordinates data
Goto Forum:
  


Current Time: Thu Dec 08 16:14:42 CST 2016

Total time taken to generate the page: 0.12818 seconds