-
hi people
take a look at
http://www.geocities.com/anony_mousuk/tables2.TXT
im trying to design a database from that data..
now all the tables are creating fine and ok..
but when i get to the tool contract lines i get the error
ORA-02291: integrity constraint (OCLA041.PK_CI_TOOL_CONTRACTS) violated -
parent key not found
i have no idea?
any one can help please?
thanks
saj
-
Hi Saj,
The parent key (in TOOL_CONTRACTS) is not found for the values being inserted in TOOL_CONTRACT_LINES. The values for CONTRACT_ID in TOOL_CONTRACT_LINES are: 'AZ15', 'AZ16', 'AZ17', etc. but the values present in TOOL_CONTRACTS are 'Az15', 'Az16', 'Az17', etc. (the character 'z' is in lower case). Make this correction and the script will work fine.
Good Luck.
Pinakin.
-
Kindly goto this site again. and check for data in the following 2 tables. TOOL_CONTRACTS and TOOL_CONTRACT_LINES. The data doesn't match for the contract_id columns. This is the error.
Hope this helps u. All The Best.