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

LSX-00002: root element is not <schema>

1 Answers  


ORA-30101: unknown parameter name 'string'

1 Answers  


ORA-32628: invalid nesting of MODEL cell reference

1 Answers  


ORA-19652: cannot apply offline-range record to datafile string: file is fuzzy

1 Answers  


PLW-05003: same actual parameter(string and string) at IN and NOCOPY may have side effects

1 Answers  






ORA-02451: duplicate HASHKEYS specification

1 Answers  


IMG-00716: source image format does not support process options

1 Answers  


ORA-31619: invalid dump file "string"

1 Answers  


ORA-15045: ASM file name 'string' is not in reference form

1 Answers  


ORA-30151: File already exists

1 Answers  


ORA-14283: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION

1 Answers  


TNS-12566: TNS:protocol error

1 Answers  


Categories