Re: Integrity constraint
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Tue, 03 Feb 2009 18:28:05 +0100
Message-ID: <49887ea5$0$2870$ba620e4c_at_news.skynet.be>
vm22 schreef:
> Hi,
>
> I have a developer who has written the following code to delete some
> records:
>
> DELETE FROM x
> WHERE id NOT IN (SELECT id
> FROM y)
> AND id NOT IN (SELECT id
> FROM z);
>
> ORA-02292: integrity constraint (Y_FK) violated - child record found
>
> When there is already a clause in my delete to state do not delete
> records that are found in table Y, why do I get the integrity
> constraint error message?
>
>
>
>
Date: Tue, 03 Feb 2009 18:28:05 +0100
Message-ID: <49887ea5$0$2870$ba620e4c_at_news.skynet.be>
vm22 schreef:
> Hi,
>
> I have a developer who has written the following code to delete some
> records:
>
> DELETE FROM x
> WHERE id NOT IN (SELECT id
> FROM y)
> AND id NOT IN (SELECT id
> FROM z);
>
> ORA-02292: integrity constraint (Y_FK) violated - child record found
>
> When there is already a clause in my delete to state do not delete
> records that are found in table Y, why do I get the integrity
> constraint error message?
>
>
>
>
You need to give the definition of Y_FK, else we can keep on guessing. Received on Tue Feb 03 2009 - 11:28:05 CST