Re: What is ORA-2292 ?

From: Dave Crowson <dcrowson_at_amoco.com>
Date: Fri, 10 Mar 1995 12:53:30
Message-ID: <dcrowson.1167.000CE4B1_at_amoco.com>

In article <3jlb40$kr8_at_bs33n.staffs.ac.uk> cm1bcmlm_at_bs47c.staffs.ac.uk (Mark Liew) writes:
>From: cm1bcmlm_at_bs47c.staffs.ac.uk (Mark Liew)
>Subject: What is ORA-2292 ?
>Date: 8 Mar 1995 22:29:20 GMT
 

>Hi,
 

>Can anyone tell me what is ORA-02292 ? I can't seem to find it in the manuals.
>I get it when I'm trying to delete data from several tables within a
>KEY-DELREC form trigger (SQL*FORMS 3.0).
>Thanx.

02292, 00000,"integrity constraint (%s.%s) violated - child record found"

// *Cause: attempted to delete a parent key value that had a foreign
//      key dependency.
// *Action: delete dependencies first then parent or disable constraint.


__________________________________________________________________
David Crowson                        Oracle Consultant (since '83) 
igotan_at_ombomb.demon.co.uk             weirdguy_at_cix.compulink.co.uk

'Hit them in the Face, with a Funky Bass, for a Happy Smiling Race' Received on Fri Mar 10 1995 - 12:53:30 CET