ORA - 02291, ORA - 02292 Errors
444621Nov 21 2007 — edited Nov 21 2007Gurus,
When I run the following update statement, I got the following error
update dept
set deptno = 50
where deptno = 20
ORA - 02292: Integrity constraint(SCOTT.FK_DEPTNO) violated - Child record found
######################################################
When I run the following update statement, I got the following error
update emp
set deptno = 50
where deptno = 20
ORA - 02291: Integrity constraint (SCOTT.FK_DEPTNO) violated - parent key not found
I need couple of things here:
1. I want to update the dept table deptno
2. If I update the dept.deptno, corresponding child rows emp.deptno also needs to be update with new values.
How can I do this ?
Thanks.
S