Skip to content

Ch2: Invalid FK for distribution_channel_relationship_party_relationship_fk  #3

@dfhawthorne

Description

@dfhawthorne

Adding FK for:

Error starting at line : 174 in command -
ALTER TABLE distribution_channel_relationship
    ADD CONSTRAINT distribution_channel_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