Nothing to do with DBD::Oracle actually as this is the DBI part of the code And yes there is a such a thing check out Batch fetching in the DBI pod there are lots of options such as fetchrow_arrayref, fetchall_arrayref and selectall_arraryref By the way you would be much better off posting your question to dbi-users@perl.org (you don't need to subscribe in order to post, and you won't be automatically subscribed either as very few people use this form for dbi or driver support. dbi-users is where you'll get the best support