Friday 13 April 2012

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

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

Cause: (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 loadfromfile, the end of the source LOB or FILE value was reached before the specified input amount was copied or loaded.

Action: (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 or FILE given the starting source offset. Either decrease the starting source offset, or decrease the amount to copy or load.

No comments:

Post a Comment