Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Abstract Data Types Question...

Re: Abstract Data Types Question...

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 24 Nov 2003 23:58:01 +0100
Message-ID: <f535sv8i5u6cdd24ugl1mvt1bslgf32d6o@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US