OraFAQ Forum: SQL & PL/SQL » How to debug "Error: Child Recod Found"

Home » SQL & PL/SQL » SQL & PL/SQL » How to debug "Error: Child Recod Found"

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

How to debug "Error: Child Recod Found" [message #8975]

Wed, 08 October 2003 12:22

Muhammad Waqas Shabir
Messages: 26
Registered: April 2003

Junior Member

How to debug "Error: Child Recod Found"

I have Made following tables:
Create TABLE WING(
W_CodV35Pk VARCHAR2(35),
W_DescV100 VARCHAR2(100),
CONSTRAINT W_PK PRIMARY KEY (W_CodV35Pk)
);

Create TABLE THEMATIC_AREA(
TA_CodV35Pk VARCHAR2(35),
TA_W_CodV35PkFk VARCHAR2(35),
TA_DescriptionV50 VARCHAR2(50),
CONSTRAINT TA_PK PRIMARY KEY (TA_CodV35Pk,TA_W_CodV35PkFk),
CONSTRAINT TA_FK1 FOREIGN KEY (TA_W_CodV35PkFk) REFERENCES WING(W_CodV35Pk)
);

Create TABLE SYSTEM_ROLE(
SR_CodV35Pk VARCHAR2(35),
SR_DescV50 VARCHAR2(50),
CONSTRAINT SR_PK PRIMARY KEY (SR_CodV35Pk)
);

Create TABLE DESIGNATION(
Des_CodV35Pk VARCHAR2(35),
des_W_CodV35PkFk VARCHAR2(35),
Des_DescV50 VARCHAR2(50),
CONSTRAINT Des_PK PRIMARY KEY (Des_CodV35Pk,des_W_CodV35PkFk),
CONSTRAINT Des_FK1 FOREIGN KEY (Des_W_CodV35PkFk) REFERENCES WING(W_CodV35Pk)
);
------------------------------------
Create TABLE SYSTEM_USER(
SU_NameV50Pk VARCHAR2(50),
SU_PwdV35Pk VARCHAR2(35),
SU_W_CodV35PkFk VARCHAR2(35),
SU_TitleV35 VARCHAR2(35),
SU_Des_CodV35Fk VARCHAR2(35),
SU_EmailV35 VARCHAR2(35),
SU_QualificationV300 VARCHAR2(300),
SU_SpecializationV300 VARCHAR2(300),
SU_JobDescV300 VARCHAR2(300),
SU_ExpV300 VARCHAR2(300),
SU_SecQuestV100 VARCHAR2(100),
SU_SecAnsV100 VARCHAR2(100),
SU_SessTimeoutV2 VARCHAR2(2),
SU_Statusv1 VARCHAR2(1),
CONSTRAINT SU_PK PRIMARY KEY (SU_NameV50Pk,SU_PwdV35Pk,SU_W_CodV35PkFk),
CONSTRAINT SU_FK1 FOREIGN KEY (SU_W_CodV35PkFk) REFERENCES WING(W_CodV35Pk),
CONSTRAINT SU_FK2 FOREIGN KEY (SU_Des_CodV35Fk,SU_W_CodV35PkFk) REFERENCES DESIGNATION(Des_CodV35Pk,Des_W_CodV35PkFk)
);

Create TABLE ROLE_ASSIGNMENT(
RA_SU_NameV50PkFk VARCHAR2(50),
RA_SU_PwdV35PkFk VARCHAR2(35),
RA_TA_CodV35PkFk VARCHAR2(35),
RA_W_CodV35PkFk VARCHAR2(35),
RA_SR_CodV35PKFk VARCHAR2(35),
CONSTRAINT RA_PK PRIMARY KEY (RA_SU_NameV50PkFk,RA_SU_PwdV35PkFk,RA_TA_CodV35PkFk,RA_SR_CodV35PKFk),
CONSTRAINT RA_FK1 FOREIGN KEY (RA_SU_NameV50PkFk,RA_SU_PwdV35PkFk,RA_W_CodV35PkFk) REFERENCES SYSTEM_USER(SU_NameV50Pk,SU_PwdV35Pk,SU_W_CodV35PkFk),
CONSTRAINT RA_FK2 FOREIGN KEY (RA_TA_CodV35PkFk,RA_W_CodV35PkFk) REFERENCES THEMATIC_AREA(TA_CodV35Pk,TA_W_CodV35PkFk),
CONSTRAINT RA_FK4 FOREIGN KEY (RA_SR_CodV35PKFk) REFERENCES SYSTEM_ROLE(SR_CodV35Pk)
);
------------------------------------

When i update the values of primary key[[RA_SU_NameV50PkFk]] in master table[[System_user]], i get this error "Error: Child Recod Found" which says that i am violating RA_FK1. Despite of the fact that children should be automatically be updated.

So i can not do update operation on my site.

What is causing this & How to eliminate this?

Thanks in anticipation.

Report message to a moderator

Re: How to debug "Error: Child Recod Found" [message #8979 is a reply to message #8975]

Wed, 08 October 2003 13:37

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

"Despite of the fact that children should be automatically be updated."

How are you expecting them to be automatically updated? Oracle certainly isn't doing it. An update of a PK is a bad, bad idea. A PK value should never change.

Cascading updates

Report message to a moderator

Previous Topic:	speeding up top-N analysis
Next Topic:	trigger help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 02:43:34 CDT 2024