Object Types

Hello Please help

create type ferien as object (id number,bez varchar2(80),hit number); create type arr_ferien as table of ferien;

now i have create a package where a create a variable of arr_ferien type

in the package the array woul be filled. in the package exist a function that would return ferien objects ! And now i would create a view where i can select the coloums of ferien object.

create or replace view v_test as
select package.get_ferien_object(x) ferien_obj from dummy where rownum <= (select package.get_max_ferien_objects from dual);

i want now to select the coloumns from the object but it dont't work

SELECT ferien_obj.id,ferien_obj.bez,ferien_obj.hit FROM v_test ORDER BY ferien_obj.hit Received on Wed Jul 01 1998 - 00:00:00 CDT