Re: create type error

Sybrand Bakker wrote:

> 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

And VARCHAR2 ... not VARCHAR.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
(remove one 'x' from my email address to reply)