Re: Can data cached in array be lost ?

Depends on the version. But in some, yes, it can. see:

Note.292034.1 WRONG RESULTS FROM QUERIES ON TABLES CONTAINING USER-DEFINED = TYPES
Bug 4007071 - Wrong Results Selecting From User-Defined Table --->Fixed in 9.2.0.7

Bug 4148420 QUERY PRODUCES DIFFERENT RESULTS WHEN INSERTING TO A TABLE (unpublished)
--->Appears this will not be fixed in 9.2.0.7 patchset (Will need a one-off patch)

Bug 4403930 QUERY RETURNS INCORRECT RESULTS FROM TABLE FUNCTION BASED ON VIRTUAL TABLE Possible workaround:

_table_lookup_prefetch_size=3D0

• Vlad

On 6/9/05, Ranko Mosic <ranko.mosic_at_gmail.com> wrote:
> Hi all,=3D20
> I know this is vague, but this is all the data I have.
> Seems like data that is cached in array ( PL/SQL collection ) is being
> lost somehow.
> This program was working many times before in other environments.
> PGA is automatically managed. =3D20
>=20
> Regards, Ranko.
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l