Re: type where it belongs

"Thorsten Kettner" <thorsten.kettner_at_web.de> wrote in message news:74a9c367.0309142332.7cb70fbc_at_posting.google.com...
> 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 :)

Please try to LEARN Oracle, and do not just start SOMEWHERE, like you do.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address