Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: type where it belongs
Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<1063289917.55646_at_yasure>...
> Thorsten Kettner wrote:
> >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;
> >
> > select * from table(GetNumbers(100,200))
> >
> >returns ORA-00902 invalid data type.
> Define the type in a package header and identify the type in your code
> as package_name dot type.
Thank you very much for your answer Daniel. Unfortunately this does not solve the problem (I still get the error), but - strange enough - I found out that I don't get this error if I return the records pipelined. As this technique seems to be superior anyhow, I will henceforth write all my functions pipelined. Thus I am rid of the problem :) Received on Mon Sep 15 2003 - 02:32:22 CDT