Question

I try to insert data into one of the table causes but I got an error message, I don't know how to resolve this

SQL> CREATE TABLE Causes(cid NUMBER(5) PRIMARY KEY, name VARCHAR2(20) REFERENCES Signup, problem VARCHAR2(256), location VARCHAR2(200),fund NUMBER(30));

Table created.

SQL> CREATE TABLE Causes(cid NUMBER(5) PRIMARY KEY, name VARCHAR2(20) REFERENCES Signup, problem VARCHAR2(256), location VARCHAR2(200),fund NUMBER(30));

Table created.

SQL> describe Signup;
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
USERNAME                                  NOT NULL VARCHAR2(50)
PASSWORD                                           VARCHAR2(50)
NAME                                      NOT NULL VARCHAR2(100)
AGE                                                NUMBER(5)
PHONE                                              CHAR(20)
ADDRESS                                            VARCHAR2(200)

SQL> describe Causes;
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
CID                                       NOT NULL VARCHAR2(5)
NAME                                               VARCHAR2(20)
PROBLEM                                            VARCHAR2(256)
LOCATION                                           VARCHAR2(200)
FUND

ERROR MESSAGE :

SQL> insert into Causes values(100, 'kamal', 'floods', 'australia', 2000);
ERROR at line 1:
ORA-02291: integrity constraint (GILLIK.SYS_C0063904) violated - parent key not found

Answer 1

ORA-02291 is typically accompanied with the message, “integrity constraint (GILLIK.SYS_C0063904) violated – parent key not found”. This means that you attempted to execute a reference to a certain table using a primary key. However, in the process of doing so, the columns that you specified failed to match the primary key. The error can also be triggered when referencing a primary key that does not exist for the table in question.

In order to remedy this error, you will need to insert the value that you attempted to place in the child table into the parent table first. Once inserted as a parent row, you can go back and insert the value into the child table.

So, first you need to insert your data in Signup Table after than you can insert your data in Causes table.