Oracle Error SQL*Loader-00456: end of collection found after number elements when looking for number elements

Oracle Error Message

SQL*Loader-00456: end of collection found after number elements when looking for number elements

Reason for the Error

A count value was specified for a varray or nested table column and the number of rows found is less than the number of rows specified

Solution

Verify that the count field has the correct value and that there is no missing data for the collection.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...