I think the solution could be split in two parts: to paginate the results, you can use Data::Page. To fetch only the data you're interested to from Oracle, you have to implement a LIMIT mechanism, which isn't available in Oracle, AFAIK.