simple query with types problem

create or replace type IndirizzoTY as object
(via varchar(30),

comune varchar(20),
provincia char(2));

create or replace type PersonaTY as object
(cognome varchar(20),

nome varchar(15),
indirizzo indirizzoTY);

create table Persona of PersonaTY;

insert into persona values('Insegno','Pino',IndirizzoTY('Via Dante','Roma','Rm'));

select indirizzo.via from persona;

ORA-00904: "INDIRIZZO"."VIA": identificativo non valido

....
Which is the correct sql command? Received on Sun Nov 09 2008 - 03:43:26 CST