problems with select (oo)

hi there,
i've got some trouble with oo-types and queries. here's some code:

create type telnr_ty as object(vorwahl number, rufnummer number); /
create table test (land char, telefon telnr_ty);

insert into test values('D', telnr_ty(930248, 49536));
insert into test values('D', telnr_ty(956767, 67736));
insert into test values('P', telnr_ty(930248, 3536));

select * from test;                    -- works perfectly...
select telefon from test;              -- works as well...
select telefon.vorwahl from test;      -- doesn't work!

i got a message:

select telefon.vorwahl from test

               *
ERROR at line 1:
ORA-00904: invalid column name

could anybody help me, please?

is that just another bug, like the required "/" after "create type..."? i also tried the samples from the oracle reference. i typed in them _correctly_, they didn't work. do i have to set any special options in sql*plus to tell them i want to just objects?

i also tried
select telnr_ty.vorwahl from test;
without success!
Thanx for any hints, (possibly in German???)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Mar 07 2000 - 00:00:00 CST