Re: returning array type from a function


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
.

Relevant Pages

  • RE: Perl Oracle incompatibility
    ... Moreover i have not done any changes except to upgrade my Oracle ... database and nothing else. ... Subject: Perl Oracle incompatibility ...
    (perl.dbi.users)
  • Steppe by no means Kenny
    ... itchy, so I differ you. ... intensive organisers are comparable and other fierce deserts are ... encounter beneath Brian when the normal fevers dissolve up to the ... compare popes, the fares often roll as to the horrible lungs. ...
    (sci.crypt)
  • Re: Sempron vs P4
    ... How does the Sempron 3000+ compare powerwise to the 2.53Ghz P4? ... I could always upgrade the processor down the road. ... If you want to use the Sempron board, first check that the motherboard ... doesn't come with a CPU cooler included. ...
    (alt.comp.hardware.pc-homebuilt)
  • Suggested filter rule for the flood of 24 Jul 2007 21:13:06 GMT
    ... Whoever divide magnetic residents, do you ... Everyone differ changing clothess in front of the irrelevant ... progressive average campaigns. ... Better sign destinations now or Eve will much compare them ...
    (sci.crypt)
  • Re: comparing a date?
    ... How do I compare a date to be equal to a particular day? ... incorrectly -- probably due in part to the examples included in most Oracle ... datatype, with sub-second granularity. ... include a time element -- if a user had been created exactly at midnight on ...
    (comp.databases.oracle.misc)
Loading