type where it belongs

I have a table type definition

 type t_numbers is table of number

and a function returning this table type

 Function GetNumbers(p_min IN number, p_max IN number) RETURN t_numbers;

Problem is, I would like to put them in a package to avoid to have tens of thousands of types and functions floating freely around some day. But it seems I must keep the type outside the package, because otherwise the select

  select * from table(GetNumbers(100,200))

returns ORA-00902 invalid data type.

It's hard to believe that the dbms looks into the package to find and execute the function, but is too lazy to look for the data type definition there, too.

Hence the question: Must I change the select somehow? Must I change something in the package (maybe specify an export keyword with the type)? Or is it really impossible to place the result type in the package and be able to select? If so, where does one place enhancement requests? Received on Thu Sep 11 2003 - 03:56:34 CDT