-
ORA-02291: integrity constraint (S3034595.FKPOSITION_ID) violated - parent key not fo
hi
i have the above error the
follwing is the position table
CREATE TABLE POSITION
( POSITION_ID CHAR(8) NOT NULL,
DESCRIPTION VARCHAR2(50),
DUTIES VARCHAR2(50),
SALARY CHAR(15),
LEVEL_NO CHAR(15),
CONSTRAINT PKPOSITION PRIMARY KEY (POSITION_ID) );
and the job table
CREATE TABLE JOB
( JOB_NUMBER CHAR(8) NOT NULL,
DATE_CREATED DATE,
DEPT_ID CHAR(9),
POSITION_ID CHAR(9),
CONSTRAINT PKJOB PRIMARY KEY (JOB_NUMBER),
CONSTRAINT FKDEPT_ID FOREIGN KEY (DEPT_ID ) REFERENCES DEPARTMENT,
CONSTRAINT FKPOSITION_ID FOREIGN KEY (POSITION_ID ) REFERENCES POSITION);
when i use
insert into job
values(31002,'1/july/2001',26001,27002);
ther is an error
ORA-02291:integrity constraint (FKPOSITION_ID) violated - parent key not found
i have allready created data in position table for position_id 27002
help appreciated
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|