Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
ORA-01779 when updating a view (Read 1059 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
ORA-01779 when updating a view
13.06.14 at 10:28:09
 
ORA-01779 when updating a view
 
The following error is received when updating a collumn in a view from Oracle Forms:
ORA-01779: cannot modify a column which maps to a non key-preserved table
 
The column in the view is updatable.
 
The problem is that the view needed a primary key. In Oracle designer in the view definition a primary key for the view needed to be set.
Back to top
 
« Last Edit: 13.06.14 at 10:29:24 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1