Am trying to navigate the result set from an Oracle function and it all works well using ocifetchstatement by reading the data into an array then traversing that.

However, the data size is going to increase to about 500,000 records - has anyone got any experience of using ocifetchstatement with a result set that size?

Can't seem to find any documented limit to the size of an array - and was wondering if anyone had 'broken' one yet?

Cheers for any info.