Oracle Database Discussions

Hi,

I have the following script;:

But when I execute the script, TOAD gives me in line "create table recipiente", (I have put in bold the line), the following error: ORA-02256: number of referencing columns must match referenced columns. But I don´t know where is the error.

create table bodega
( nombrebodega varchar2(50) primary key,
localidad varchar2(50),
nombredueño varchar2(50),
telefono varchar2(50),
museo char(1),
logo blob
);


create table vino
( tipovino varchar2(50),
categoriavino varchar2(50),
anovendimia number(4),
nombrebodega varchar2(50),
denominacionorigen varchar2(50),
precio_lproduc number(5),
litrosproduc number(10),
precio_lpublico number(5),
primary key (tipovino,categoriavino,anovendimia,nombrebodega),
foreign key (nombrebodega) references bodega on delete cascade
);


create table recipiente <-- Here gives me the error
( idrecipiente number(2) primary key,
capacidad number(10),
clase varchar2(50),
tipovino varchar2(50) not null,
categoriavino varchar2(50) not null,
anovendimia number(4) not null,
nombrebodega varchar2(50) not null,
foreign key (tipovino) references vino on delete cascade,
foreign key (categoriavino) references vino on delete cascade,
foreign key (anovendimia) references vino on delete cascade,
foreign key (nombrebodega) references vino on delete cascade
);

Anybody could help me?

Thanks. Regards