Re: problems with select (oo)

> 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?

This statement:

select t.telefon.vorwahl from test t;

should work (I hope so).

Regards
Maciek Received on Thu Mar 09 2000 - 00:00:00 CST