Oracle Error Message
ORA-24370: illegal piecewise operation attempted
Reason for the Error
Data of a certain datatype that does not support piecewise operation is being sent or fetched in pieces.
Solution
Always set the piece value to OCI_ONE_PIECE for datatypes that does not support piecewise operation.