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

You wont be able to create a foreign key with a partial primary key. Your master table has a composite primary key but you are trying to reference a key which is not primary at all.

Ex.

what if the data is like this for Form1 table:

1        Share1        1/1/1980
2        Share1        1/1/1980

As shown above even though it is perfectly valid for the master table (Form1) it violates the primary key (deemed) for ShareCapital table since there are duplicates. The only way to fix this is to fix either your master table (include a surrogate key) or to include Empcid in ShareCapital.

Hope this helps.

Happy Programming!!!

Regards,
Raja

 create table sharecapital( 
        loanid         varchar2(25), 
        loandt        date,
        empshare    varchar2(10),
        empedoj      date,
        foreign key (empshare) references form1 (empshare) on delete cascade,
        foreign key (empedoj) references form1 (empedoj) on delete cascade
);