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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19621: archivelog range has already been specified

1 Answers  


EXP-00085: The previous problem occurred when calling string.string.string for object number

1 Answers  


SQL*Loader-00436: error converting GUID

1 Answers  


ORA-27507: IPC error disconnecting from a port

1 Answers  


NNO-00069: warning: too many administrative region check failures, checking disabled

1 Answers  






ORA-26027: unique index string.string partition string initially in unusable state

0 Answers   MeritTrack,


ORA-16727: resource guard cannot close database

1 Answers  


NCR-00003: NCR: Initialization failure

1 Answers  


PLS-00172: string literal too long

1 Answers  


QSM-00778: the specified output filename string is invalid or cannot be accessed

1 Answers  


QSM-00758: the specified parameter string is not valid for workload string

1 Answers  


SQL*Loader-00127: Invalid maximum record size

1 Answers  


Categories