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

Re: create type error

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 22 Apr 2003 17:41:04 GMT
Message-ID: <b83urg$5t1ic$1@ID-82536.news.dfncis.de>

> 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.html
Received on Tue Apr 22 2003 - 12:41:04 CDT

Original text of this message

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