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-24150: evaluation context string.string does not exist

1 Answers  


ORA-29369: invalid method name string specified for consumer group string

1 Answers  


ORA-01147: SYSTEM tablespace file string is offline

1 Answers  


RMAN-06063: DBID is not found in the recovery catalog

1 Answers  


ORA-31523: could not find change source string for CDC change set string

1 Answers  


LPX-00404: unable to resolve namespace URI

1 Answers  


ORA-13857: Invalid module name

1 Answers  


ORA-26566: Couldn't open connect to string

1 Answers  


ORA-31121: The string operator can not be FALSE

1 Answers  


ORA-27464: invalid schedule type string

1 Answers  


ORA-27509: IPC error receiving a message

1 Answers  


ORA-24784: Transaction exists

1 Answers  


Categories