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/FILE value was reached before the specified input amount was copied/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/FILE given the starting source offset. Either decrease the starting source offset, or decrease the amount to copy/load.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-22993：指定的输入量大于实际源量,
.原因：（1）对于LOB写入，接收的数据量与指定的数据量不同。（2）对于LOB copy和loadfromfile，在复制/加载指定的输入量之前到达源LOB / FILE值的结尾。,
.操作：（1）将在使用OCI的分段机制与轮询或回调函数时发生。修改代码以发送指定的数量或传递0作为输入量，以便可以发送任何数量的数据。（2）如果指定的输入量对于给定起始源偏移的源LOB / FILE来说太大，则会发生。要么减小起始源偏移，要么减少复制/装载的数量。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题