Hello,
Thank you very much for the help.
Now I'm able to create user defined types, but I still cannot figure out how
to inherit one datatype from another.
So, I define a type:
> create or replace type Persontype as Object (
> PersNr integer,
> Name varchar(30)
> );
> /
Then I inherit a new type from the above-defined type:
> create or replace type Studenttype under Persontype (
> team number
> );
-- no errors
But, when I try to make a table to the inherited "Studenttype":
> create table test of Studenttype
--it gives an "Invalid datatype" error.
Any help would be appreciated.
Thanks a lot,
Roman Zhovtulya
"Finn Ellebaek Nielsen" <_remove_fen_remove__at_changegroup.dk> wrote in
message news:3de14d3f$0$214$edfadb0f_at_dread14.news.tele.dk...
> Because there's a comma after the second attribute:
>
> create or replace type Persontype as Object (
> PersNr integer,
> Name varchar(30),
> );
> /
>
> The correct version is
>
> create or replace type Persontype as Object (
> PersNr integer,
> Name varchar(30)
> );
> /
>
> (you use the comma to separate attributes and methods).
>
> HTH.
>
> Finn
>
> --
> --------------------------------------------------------------------------
-
> Finn Ellebaek Nielsen ChangeGroup ApS
> Product Manager, Principal Consultant, Partner Kronprinsessegade 54, 4.
> E-mail: finn.ellebaek.nielsen_at_changegroup.dk DK-1306 Koebenhavn K
> Mobile: +45 20 32 49 25 Denmark
> Phone: +45 33 32 77 78 http://www.changegroup.dk
> --------------------------------------------------------------------------
-
> "Where do you want to GPF today?"
> "Roman Zhovtulya" <roman_at_fh-offenburg.de> wrote in message
> news:arrcr8$s1l$1_at_news.BelWue.DE...
> > Hello Dennis,
> > Thanks a lot for the help and explanations.
> > I've tried compiling the following:
> > -----
> > create or replace type Persontype as Object
> > (
> > PersNr integer,
> > Name varchar(30),
> > );
> > /
> > -----
> > , but it kept on giving "compiled with errors".
> >
> > I searched Google and came accross the following line:
> > ----
> > map member function map_function return varchar2
> > ----
> > If I add it after "Name varchar(30)", it works flawlessly.
> > (i.e,
> > ----
> > create or replace type Persontype as Object
> > (
> > PersNr integer,
> > Name varchar(30),
> > map member function map_function return varchar2
> > );
> > /
> > ----
> >
> > Any idea of why it's needed there?
> >
> > Thanks a lot,
> > Roman Zhovtulya
> >
> >
> >
> > "Dennis Petersen" <fessor_at_software.dk> wrote in message
> > news:arqktd$gkk$1_at_news.cybercity.dk...
> > > > 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 Mon Nov 25 2002 - 11:00:46 CST
