Skip to content

Ch2: Invalid FK for organization_contact_relationship_party_relationship_fk  #6

@dfhawthorne

Description

@dfhawthorne

Adding FK fails with:

Error starting at line : 396 in command -
ALTER TABLE organization_contact_relationship
    ADD CONSTRAINT organization_contact_relationship_party_relationship_fk FOREIGN KEY ( from_date )
        REFERENCES party_relationship ( from_date,
                                        party_role_party_role_id,
                                        party_role_party_party_id,
                                        party_role_party_role_id2,
                                        party_role_party_party_id2 )
    NOT DEFERRABLE
Error report -
ORA-02256: number of referencing columns must match referenced columns
02256. 00000 -  "number of referencing columns must match referenced columns"
*Cause:    The number of columns in the foreign-key referencing list is not
           equal to the number of columns in the referenced list.
*Action:   Make sure that the referencing columns match the referenced
           columns.

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions