Re: oracle 7.0.12, ref integrity problem...
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