Oracle Error ORA-32161: Cannot perform piecewise fetch

Oracle Error Message

ORA-32161: Cannot perform piecewise fetch

Reason for the Error

Zero amount was passed and buffer size was less than LOB size

Solution

Specify a larger buffer or use Stream