Oracle Error ORA-24817: Unable to allocate the given chunk for current lob operation

Oracle Error Message

ORA-24817: Unable to allocate the given chunk for current lob operation

Reason for the Error

The given size is increased to accomodate the number of bytes from server due to varying width db char/nchar set.

Solution

Use smaller chunk sizes when you have character set conversion between client/server or perform piece-wise read or write.