JDBC Oracle Cursor Vs Array

[Babji Reddy]

In JDBC using Oracle Oci driver
Which one does perform better processing multiple (thousands) records?
Using cursor of records (using ResultSet)
or
Array of objects (using ARRAY of STRUCT )
Thanks

[Jeanne Boyarsky]

Babji,
I have no idea, but to help others who might - what are you trying to do? A select, an update, an insert, ...?

You could also try it by writing a simple program that does it both ways.

[Babji Reddy]

Mostly its selects, but there could be few inserts too.
I want to know the standarad practise that people use in enterprise applications.
Thanks