Unix C++
Would you like to react to this message? Create an account in a few clicks or log in to continue.

cascade on update using triggers

Go down

cascade on  update using triggers Empty cascade on update using triggers

Post by aarthi Tue Apr 13, 2010 6:33 pm

create or replace trigger aartri
after update or delete
on disks_337517
for each row
begin
update ssimple set disk_id=:new.disk_id where disk_id=:old.disk_id;
end;
/

if i execute my trigger gets created....
i have a value for disk_id 4 in both the tables...
when i tried to update..
update disks_337517 set disk_id=9 where disk_id=4;
am getting error,
integrity constraint (SCOTT.DID) violated - child record found

aarthi

Posts : 12
Points : 22
Join date : 2010-02-26

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum