Re: create type error

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 22 Apr 2003 06:51:39 +0200
Message-ID: <dhi9av8mmkurlej7v2iravcnemphqagti5@4ax.com>

On Tue, 22 Apr 2003 03:06:03 GMT, "Mike" <ti_mich_at_hotmail.com> wrote:

>Hi,
>
>I create a type :
>create type Personne
>(nom varchar(20),
>adresse varchar(20));
>
>I obtain this :
>Warning: Type created with compilation errors.
>
>and a table :
>create table personnes of Personne;
>
>and I got this error :
>create table personnes of personne
>*
>ERROR at line 1:
>ORA-00902: invalid datatype
>
>
>Why ? Anyone can help me.
>
>Thanks
>
>
>

create type Personne
(nom varchar(20),
adresse varchar(20));
/ --------------- Mark the extra /

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Apr 21 2003 - 23:51:39 CDT