How to fetch huge amount of data from a oracle procedure

by Gibreel Abdullah   Last Updated August 10, 2018 12:06 PM - source

I am working on a procedure (written by someone else), which bulk collects millions of rows, stores them in a 2 dimensional array variable and sends it to the Java backend.

It used to work fine, except that the data grew so huge that it started throwing 'out of memory' exception.

What could be an efficient approach to deal with this?

Tags : oracle

Related Questions

Altering the location of Oracle-Suggested Backup

Updated July 03, 2016 08:02 AM

Ways to Schedule Rman backups

Updated February 24, 2017 12:06 PM

EMCA insists that it cannot connect to the service

Updated August 28, 2017 14:06 PM

Password for Oracle Database 18c user “system”

Updated August 02, 2018 06:06 AM