Re: Creating types in Orace 9i: any help?

> create type Persontype
> (
> PersNr integer,
> Name varchar(30),
> primary key (EmpNr)
> );

You need to tell that it is of an object type, also use the create or replace if you plan to use a script that you can just run again every time you change something...
Another thing is that you declare a primary key ? This is not for the object but could very well be on the table where you want to insert the object... so try the following:

create or replace type Persontype as Object (

    PersNr integer,
    Name varchar(30),
);
-- The / tells Oracle that the definition is done and it should compile the object...
/
-- Now here's a table that can contain the Persontype objects create table people(

    EmpNr integer,
    person PersonType,
    CONSTRAINT pk_people PRIMARY KEY(EmpNr) );
-- Note you could easily just declare a table of Persontype type and Oracle will assign an OID (Object ID) as a unique identifier... like this -- create table people of Persontype

Hope it helps...
Sincerely,
Dennis P Received on Sun Nov 24 2002 - 07:42:29 CST