Re: oracle 7.0.12, ref integrity problem...

From: David Thornewill von Essen <ttg242_at_newton.sps.mot.com>
Date: Wed, 30 Jun 1993 14:36:19 GMT
Message-ID: <1993Jun30.143619.19292_at_newsgate.sps.mot.com>


In article gcs_at_ucunix.san.uc.edu, swaminrn_at_ucunix.san.uc.edu (Radhakrishnan Swaminathan) writes:
>Hi,
>
> I am designing the DB layer where v will b using oracle 7.0.12.
>I have a child table T with 3 columns defined as foreign keys on 3
>different parent tables. On an insert the manual says for a referential
>integrity violation, I'll get 2291. But I couldn't get any info on which
>table that gave this constraint problem. I had to do a select on those 3
>parent tables, to find whether the foreign key exists as a row r not.
>I called ORACLE and they are also looking into it. I went thru'
>the DBA vol I,II & III, and other manuals and unfortunately I couldn't
>locate any pertinent info.
>
>Any pointers?
>
Perhaps you could use the EXCEPTIONS clause. I don't have the manual to hand but I seem to remember that it only works when you load a table not on tables that have been previously loaded.

---
Regards,
David TvE

+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
David Thornewill von Essen                           Sr. Systems Analyst
Motorola ASIC Division                            I don't speak for Mot.
Chandler, AZ-85224                                   fax: (602) 814-4451
email: ttg242_at_email.sps.mot.com                      tel: (602) 814-4395
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Received on Wed Jun 30 1993 - 16:36:19 CEST

Original text of this message