As Paul has mentioned you can fetch less number of records, but if the problem still persists, run the following at the SQL prompt and trying running the query.

SQL> set array 1

This sets the arraysize for you and the query should work fine.