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?
05-01-2001, 12:43 PM
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.
05-02-2001, 07:01 AM
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.