| Foreign key on updating [message #246020] |
Tue, 19 June 2007 10:35  |
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
|
Member |
|
|
Hi,
I have a small dilemma with oracle foreign keys.
Oracle give me to set up foreign key to another table, and this is ok, but it have only "on delete" rule which is set to none to protect data from erasinf while referential data is exsist.
So, is there any solution to set "on update" rule? If I have a master and detail table and foreign key which protect master record delete while detail data exsist. How to set foreign key is I UPDATE master field, to update detail field which is part of foreign key?
Thanks in advance...
|
|
|
|
| Re: Foreign key on updating [message #246027 is a reply to message #246020] |
Tue, 19 June 2007 10:48  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Oracle only implements "on delete cascade" and "on delete set null", no other option.
You can implement yours using triggers but this is very difficult (impossible?) to do it without locking the whole table.
The best way is to always update through a procedure then you can do what you want during the "update".
Regards
Michel
[Edit: add last sentence]
[Updated on: Tue, 19 June 2007 10:50] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
