Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02267: column type incompatible with referenced column type

891947Oct 2 2011 — edited Oct 3 2011
create table employee(
emp_id varchar(10) constraint PK_employee Primary Key,
firstname varchar2(20),
lastname varchar2(20),
phone number(11));

Table created.

create table empinformation
(
mobileno number(6) constraint pk_empinformation primary key,
address varchar(100),
salary number(10),
personalid number(10) constraints fk_employees_section references employee(emp_id) );



ERROR at line 6:
ORA-02267: column type incompatible with referenced column type
This post has been answered by Ritesh Singh on Oct 3 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2011
Added on Oct 2 2011
3 comments
32,917 views