column type incompatible with reference column type

[sathya venkat]

create table dep(Dept_id number ,dname varchar(25),job varchar(13),eid number, foreign key(Dept_id) references emp(eid));

what mistake i did in this code

[debasisdas]

I do not understand why dept_id refers eid

and by the way what is the data type of eid column in emp table ?

[zmbd]

Maybe... you should include the exact error message and number you received?