Foreign Key Must Have the Same Number Of Columns As the Referenced Primary Key
Lakshmeepathi Ghiree Anandh
posted 4 years ago
I get the following error when <one-to-many>(Set) is used on a table with a composite-id. i.e when TYPE_ID in CALL_CENTER_TYPE_ASSOC table ,is not a part of composite-id, <one-to-many>(Set)
Though it is <many-to-many>,I ll have only one object of CALL_CENTER_TYPE_ASSOC at a time.So,I thought <one-to-many> will retrieve multiple rows from
IM_CTIS_WORKFLOW_ASSOC.It worked when the column was not a part of composite-id.
I DO NOT HAVE THE COLUMN "CALL_CENTER_ID" AND I CANNOT ADD IT TO THE TABLE "IM_CTIS_WORKFLOW_ASSOC"
How do I get the same functionality when TYPE_ID is a part of composite-id? Please help. Thanks in advance.
Foreign key (FKDB7E233EB70B075B:IM_CTIS_WORKFLOW_ASSOC [TYPE_ID])) must have same number of columns as the referenced primary key (CALL_CENTER_TYPE_ASSOC [TYPE_ID,CALL_CENTER_ID])