Re: integrity constraint violated - parent key not found

From: Georg Scholz <georg.scholz_at_vienna.at>
Date: Wed, 23 Apr 2003 10:18:55 GMT
Message-ID: <jMtpa.197232$UR.1879223@news.chello.at>

This error means you wanted to insert some value in a field which has no matching value in some other table ("master table", "parent table").

e.g. your database has two tables: PRODUCTS and SALES. If the system is properly set up, you will not be able to insert Product-IDs into SALES which are not members of PRODUCTS. If you try, you will get the error below.

--
Georg Scholz
www.scholz-informatik.at

<mafia.merlin_at_bluemail.ch> schrieb im Newsbeitrag
news:d2eb6c9d.0304230202.70a6afec_at_posting.google.com...


> I have a litle problem, and i don't know how to resolve it. I want to

> post data in a Oracle-Table, when i try it, it returns this problem:

> Can someone help me?

>

>

> [nativecode=ORA-02291: integrity constraint (...) violated - parent

> key not found]

Received on Wed Apr 23 2003 - 05:18:55 CDT