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 -> create type error

create type error

From: Mike <ti_mich_at_hotmail.com>
Date: Tue, 22 Apr 2003 03:06:03 GMT
Message-ID: <vk2pa.28304$Ao.2614488@charlie.risq.qc.ca>


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 Received on Mon Apr 21 2003 - 22:06:03 CDT

Original text of this message

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