On 24 Nov 2003 14:38:39 -0800, DJM_666_at_msn.com (DJM) wrote:
>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
Please look at the last line of your insert statement, at
trackdetails, the second element. The starting quote is missing.
--
Sybrand Bakker, Senior Oracle DBA
Received on Mon Nov 24 2003 - 16:58:01 CST
