take a look at
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?
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.
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.
Click Here to Expand Forum to Full Width