Re: returning array type from a function
From: krzysztof cierpisz <ciapecki_at_gmail.com>
Date: Mon, 23 Mar 2009 08:53:59 -0700 (PDT)
Message-ID: <c378bb64-1591-42cb-867d-4ec1bc8ae45e_at_g19g2000yql.googlegroups.com>
>
> Try the above and if it works compare to your own code and find where
> yours differ. If it doesn't - check your Oracle version and upgrade if
> necessary. And in the future please post full code that does not
> compile so that we could try it and reproduce your issue if it's not
> obvious, not just the fragments you think are relevant.
>
>
Date: Mon, 23 Mar 2009 08:53:59 -0700 (PDT)
Message-ID: <c378bb64-1591-42cb-867d-4ec1bc8ae45e_at_g19g2000yql.googlegroups.com>
>
> Try the above and if it works compare to your own code and find where
> yours differ. If it doesn't - check your Oracle version and upgrade if
> necessary. And in the future please post full code that does not
> compile so that we could try it and reproduce your issue if it's not
> obvious, not just the fragments you think are relevant.
>
>
Thanks Vladimir,
Now I actually do not know what the issue was. Your code works fine.
In the meantime I changed my code to use the object instead of record
and that was working.
I changed now back to record, and it's working as well.
I did not commit the stage of the package where I encountered the issue (my fault).
But thanks, now I know that both table of records and table of objects works just fine.
I did it on 10gR2 (little late information - next time will provide at once)
thanks,
chris
Received on Mon Mar 23 2009 - 10:53:59 CDT