Re: What is ORA-2292 ?

From: Phil Fielder <fimad_at_archie.lanl.gov>
Date: 9 Mar 1995 02:46:57 GMT
Message-ID: <3jlq71$7nk_at_newshost.lanl.gov>


cm1bcmlm_at_bs47c.staffs.ac.uk (Mark Liew) wrote:

> 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).

126 :haruspex:ERDB% oerr ora 2292
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.

phil fielder
los alamos nat lab,nm Received on Thu Mar 09 1995 - 03:46:57 CET

Original text of this message