Oracle Error ORA-24809: amount specified will not fit in the lob buffers

Oracle Error Message

ORA-24809: amount specified will not fit in the lob buffers

Reason for the Error

LOB buffering is enabled for the input lob locator so buffering will be used. However, the amount of lob data to read or write is larger than what the lob buffers can hold.

Solution

Either disable buffering on the input lob locator and reissue the command or pass a smaller amount.