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
Bookmarks