LOGANATHAN V

LOGANATHAN V

  • NA
  • 27
  • 20.9k

ORA-02256: number of referencing columns must match referenced columns

Mar 7 2011 12:36 PM
hello friends.

Create table form1 (empcid varchar2 (25), empshare varchar2 (10), empedoj date, constraint pkform1 primary key (empcid, empshare, empedoj));

create table sharecapital(loanid varchar2(25), loandt date,empshare varchar2(10),empedoj date, constraint fkform1 foreign key (empshare,empedoj) references form1);

I need to use only empshare and empedoj in sharecapital table. But shows

ORA-02256: number of referencing columns must match referenced columns

So kindly help me to solve this problem

thanks in advance


Answers (3)