OraFAQ Forum: SQL & PL/SQL » Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table

Home » SQL & PL/SQL » SQL & PL/SQL » Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table

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

Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table [message #418202]

Thu, 13 August 2009 07:47

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

Attachment: PWR_REV_INS_PKG - Body.txt.txt
(Size: 31.05KB, Downloaded 895 times)

Report message to a moderator

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

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 ...

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://tinyurl.com/p8a2fy

Regards
Michel

Report message to a moderator

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

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

This link might help

Ross Leishman

Report message to a moderator

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

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

Attachment: PWR_REV_INS_PKG - Body.txt
(Size: 31.05KB, Downloaded 1164 times)

Report message to a moderator

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

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Hit #4 on Google is this detailed analysis from a pillar of the ORACLE community.
/forum/fa/6681/0/

/forum/fa/6681/0/

Attachment: bc.GIF
(Size: 26.91KB, Downloaded 1391 times)

Report message to a moderator

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

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Another great tip from Don

Report message to a moderator

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

Frank
Messages: 7901
Registered: March 2000

Senior Member

Quote:

Need Oracle Consulting Services?

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

Report message to a moderator

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

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

LMAO

Laughing

Report message to a moderator

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

cookiemonster
Messages: 13960
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!

Report message to a moderator

Previous Topic:	using UTL_FILE for bulk_exceptions
Next Topic:	Select Sdo_elem_Info & Sdo_ordinates data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 13:49:20 CST 2024