Re: Integrity constraint

From: ddf <oratune_at_msn.com>
Date: Tue, 3 Feb 2009 06:21:20 -0800 (PST)
Message-ID: <c7541caa-ca21-4bf3-9a6e-3a939e87050a_at_40g2000prx.googlegroups.com>

On Feb 3, 2:39 am, vm22 <vivekmarw..._at_gmail.com> wrote:
> 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?

Which release of Oracle? How are the constraints constructed? You don't provide enough information to solve this riddle.

David Fitzjarrell Received on Tue Feb 03 2009 - 08:21:20 CST