HomeOracleOracle Error SQL*Loader-00476: count of elements for collection is not set or null, 0 will be used

Oracle Error SQL*Loader-00476: count of elements for collection is not set or null, 0 will be used

Oracle Error Message

SQL*Loader-00476: count of elements for collection is not set or null, 0 will be used

Reason for the Error

This message is displayed following a message that identifies the column and row that contained the problem. The message indicates that the collection field named in the previous message has the count of elements in the collection stored in another field. This message is displayed if the field containing the count does not have a value or is set to NULL. When this happens, SQL*Loader uses 0 as the number of elements.

Solution

If 0 is not the count of elementsfor the collection, correct the data in the data file.

Share:

Leave A Reply

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

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...