Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: create type error
> 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
create type Personne as object
(nom varchar(20),
adresse varchar(20));
hth
Rene NYffenegger
-- Projektleitung und Entwicklung in Oracle/C++/C# Projekten http://www.adp-gmbh.ch/cv.htmlReceived on Tue Apr 22 2003 - 12:41:04 CDT