Oracle 8i lite. Problems with Foreign Key on TIME and DATE type columns

Is there any problem with foreign key referencing TIME or DATE type columns?

I'm using oracle 8i lite, for a university project, and I have a problem with a single foreign key.

I receive this error message:

OCA-30035: column not found
[POL-5205] column not found

When I try to set the foreign key

ALTER TABLE booking ADD
(CONSTRAINT fk_booking
FOREIGN KEY (date, time, room)
REFERENCES show(date, time, room));

between these tables

CREATE TABLE booking(
id_customer VARCHAR(6),
date DATE,
time TIME,
room VARCHAR(20),
PRIMARY KEY (id_customer, date, time, room)
);

CREATE TABLE show(
date DATE,
time TIME,
room VARCHAR(20),
movie VARCHAR(6),
PRIMARY KEY (date, time, room)
);

Thanks Received on Thu Jun 12 2003 - 09:35:49 CDT