creation type problems

#1

hey

i have problem:
with sql plus worksheet i write:

create type my_type as object(
my_string varchar2(50),
my_int integer,
my_String2 varchar2(200));

it's ok..

then
i try to do following:

create or replace type my_type2 as table of REF my_type;

and i get an error....

could someone help with it??

greetings

--

--------------------------------------

Quote:

uzi<< Wojciech U³as
gg#2160051

www.bukmacher.info
--------------------------------------

#2

which error?
/Bjørn
"uzi" <wojciech.ulas (AT) op (DOT) pl> skrev i en meddelelse
news:d3vsd6$cgm$1 (AT) news (DOT) onet.pl...

Quote:

hey

i have problem:
with sql plus worksheet i write:

create type my_type as object(
my_string varchar2(50),
my_int integer,
my_String2 varchar2(200));

it's ok..

then
i try to do following:

create or replace type my_type2 as table of REF my_type;

and i get an error....

could someone help with it??

greetings

--

--------------------------------------
uzi<< Wojciech U³as
gg#2160051
www.bukmacher.info
--------------------------------------

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

creation type problems

comp.database.oracle comp.database.oracle

creation type problems - 04-18-2005 , 03:50 AM

Re: creation type problems - 04-21-2005 , 02:30 PM