2 Replies Latest reply on Jul 22, 2013 5:40 PM by e451d5f6-f8f0-4987-ba75-dae338adceb5

    Can someone let me know why the  integrity constraint (HR.DEPENDENTS_EMPLOYEES_FK1) is violated ?

    e451d5f6-f8f0-4987-ba75-dae338adceb5

      I am just following the instructions in the Tutorial.

      Is there is a conflict between versions? I need help to move ahead.

       

      Error starting at line 1 in command:

      INSERT INTO dependents VALUES ( 210, 'David', 'Griffiths',

           TO_DATE('2-APR-99', 'dd-MON-rr'), 'son', 201)

      Error report:

      SQL Error: ORA-02291: integrity constraint (HR.DEPENDENTS_EMPLOYEES_FK1) violated - parent key not found

      02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"

      *Cause:    A foreign key value has no matching primary key value.

      *Action:   Delete the foreign key or add a matching primary key.

       

       

      Error starting at line 4 in command:

      INSERT INTO dependents VALUES ( 212, 'Jill', 'Reed',

           TO_DATE('10-FEB-92', 'dd-MON-rr'), 'daughter', 110)

      Error report:

      SQL Error: ORA-02291: integrity constraint (HR.DEPENDENTS_EMPLOYEES_FK1) violated - parent key not found

      02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"

      *Cause:    A foreign key value has no matching primary key value.

      *Action:   Delete the foreign key or add a matching primary key.

       

       

      Error starting at line 7 in command:

      INSERT INTO dependents VALUES ( 214, 'Vicki', 'Dean',

           TO_DATE('19-AUG-01', 'dd-MON-rr'), 'daughter', 201)

      Error report:

      SQL Error: ORA-02291: integrity constraint (HR.DEPENDENTS_EMPLOYEES_FK1) violated - parent key not found

      02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"

      *Cause:    A foreign key value has no matching primary key value.

      *Action:   Delete the foreign key or add a matching primary key.

       

       

      Error starting at line 10 in command:

      INSERT INTO dependents VALUES ( 215, 'Don', 'King',

            TO_DATE('24-OCT-89', 'dd-MON-rr'), 'son', 120)

      Error report:

      SQL Error: ORA-02291: integrity constraint (HR.DEPENDENTS_EMPLOYEES_FK1) violated - parent key not found

      02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"

      *Cause:    A foreign key value has no matching primary key value.

      *Action:   Delete the foreign key or add a matching primary key.