| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Insert - integrity constraint violation
The parent table does not have the value for the foreign key. Oracle
does not support cascading inserts. But some people have developed tools
to help do this. I know that Tom Kyte's site has a version of this
(http://osi.oracle.com/~tkyte/) if you are interested.
HTH,
Brian
ZC wrote:
>
> Need help,
>
> I have two tables. When I do an insert into table A, I get a message
> stating: integrity constraint (DATBASE1.A_FK_B) violated - parent key
> not found. Anyone know what I'm doing wrong that prevents me from
> entering the data into the table? The referenceor, referencee column
> are suposed to have the same type of data.
>
> I was thinking of some type of cascade insert, but I'm not sure oracle
> supports a cascade insert.
>
> Thanks for your input
> ZC
>
> A
> -----
> column1 NUMBER NOT NULL,
> column2 VARCHAR2(20) NOT NULL,
> column3 VARCHAR2(20) NULL,
> column4 VARCHAR2(20) NULL
>
> B
> -----
> columnA NUMBER NOT NULL,
> columnB VARCHAR2(20) NOT NULL,
>
> ALTER TABLE A
> ADD (CONSTRAINT A_pk
> PRIMARY KEY (column1));
> ALTER TABLE B
> ADD (CONSTRAINT B_pk
> PRIMARY KEY (columnA));
>
> ALTER TABLE A
> ADD (CONSTRAINT
> A_fk_B
> FOREIGN KEY (column4)
> REFERENCES B);
>
> --
> Someone pass a cork to plug the hole in my head
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
--
 |
 |