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)
  • Upgrade from 9i to 11g with a physical standby as well
    ... HP-UX, 9.2.0.8 EE, Running a physical standby ... B.2 Upgrading Oracle Database with a Physical Standby Database In ... Perform the following steps to upgrade to Oracle Database 11g Release ...
    (comp.databases.oracle.server)
  • 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)
  • How to upgrade a DB from 9.2.0.1 to 9.2.0.7 ???
    ... OK, now the bug disappeared... ... OLAP and Oracle Data Mining options ... exporting foreign function library names for user ME ... I looked for upgrade scripts/tools/info and the like... ...
    (comp.databases.oracle.server)