The following is the ORA-22993 error message, you can learn the cause and solution of the Oracle database error.

ORA-22993 specified input amount is greater than actual source amount


  1. For LOB write, the amount of data received is different from the amount that was indicated would be sent.
  2. For LOB copy and load from file, the end of the source LOB/FILE value was reached before the specified input amount was copied/loaded.

Solution: (1) will happen when using OCI’s piecewise mechanism with polling or with a callback function. Modify the code either to send the amount specified or to pass 0 as the input amount so that any amount of data can be sent. (2) will happen if the specified input amount is too large for the source LOB/FILE given the starting source offset. Either decrease the starting source offset, or decrease the amount to copy/load.


Please wait for the update…