Re: Oracle Object Types problem

> U can use a view splitting columns and then acces the view ?

That's no solution for me. My application knows that the second column is of type t_plz. The column names are numbered... For the application there is only ONE value of type t_plz. Splitting the type is also possible without a view:

SELECT id, t.plz.lkz, t.plz.plz from demo t;

-- 

Ciao, Udo (Mülheim a.d. Ruhr)