Oracle Error ORA-01062: unable to allocate memory for define buffer

Oracle Error Message

ORA-01062: unable to allocate memory for define buffer

Reason for the Error

Exceeded the maximum buffer size for current plaform

Solution

Use piecewise fetch with a smaller buffer size