integrity constraint??

[noel9]

hi there

i need some help!!!

ive created a database for a company.
all the tables created fine in sql.

but the problem comes when i INSERT the employee details. i have ten employees.
6 load ok but the fifth on causes a problem. ie employee 1.....employee 4 and employee 6 all work ok but the others dont.

i get an error message stating:

integrity constraint(DSA31.SYS_C00325577)
violated -
parent key not found


anyone got any idea how to solve this??

thanks
noel.

 

[tlbroadbent]

It appears that there is a foreign key on the table and the corresponding key cannot be found in the related table.

The message does not look like a SQL Server message. Which database system are you using? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[noel9]

im using sql-plus

 

[tlbroadbent]

I believe SQL*Plus is an Oracle tool. Is the backend database on Oracle? If so, you should post your question in appropriate Oracle forum. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.