Abstract Data Types Question...

I have three types...

CREATE TYPE TrackDetails AS OBJECT
(Track_Name VarChar(50),

Track_Location	VarChar(100),
Track_Length	Decimal(3,2),
Track_Diff	Integer);


CREATE TYPE Person_Details AS OBJECT


(Title		VarChar(4),

First_Name	VarChar(20),
Surname		VarChar(20),
Address		VarChar(100),
Telephone	Integer);


CREATE TABLE Race


(Race_Date	Date,

Organiser	Person_Details,
Location	TrackDetails);

I have created the three types above in SQL, but how do I then insert data into the Race table?

I have tried:

INSERT INTO Race VALUES
(1-DEC-03,

Person_Details('Mr', 'Bob', 'Jones', '123 Forest Road', 0123456789), TrackDetails('PB Races', Perry Barr', '5.5', 5));

but I get the error, ORA-01756: "quoted string not properly terminated"!

Can someone please, please help me???

Thanks in advance,
DJM Received on Mon Nov 24 2003 - 16:38:39 CST