Skip to content

Ch2: Invalid FK for supplier_relationship_party_relationship_fk  #9

@dfhawthorne

Description

@dfhawthorne

Adding FK fails with:

Error starting at line : 624 in command - ALTER TABLE supplier_relationship ADD CONSTRAINT supplier_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