Re: MERGE - INSERT/UPDATE

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 04 May 2005 15:20:22 +0200
Message-ID: <k0jh71lhp5ackgtu4ov9g45vf5ots31q25@4ax.com>

On Tue, 03 May 2005 16:36:12 GMT, "poratips shah via DBMonster.com" <forum_at_nospam.DBMonster.com> wrote:

>Hi,
>I am getting following errors while using MERGE.
>ORA-02291: integrity constraint (PTEST.SYS_C0010720) violated - parent key
>not found

...
>How can use the MERGE or another techniques to INSERT the records if it's
>not there or if it's there and any changes I can update the records?
>
>Thanks in advance!
>Poratips

There is a foreign key constraint defined on one or more columns of the table you are merging in to. You must make sure that, in the records you are to merge, the values of columns that the foreign key is defined on, exists in the columns that the foreign key refers to. Received on Wed May 04 2005 - 08:20:22 CDT