SQL*Loader-00476: count of elements for collection is not
set or null, 0 will be used
- 1 Answers
- 2659 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: 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.
Action: If 0 is not the count of elementsfor the collection,
correct the data in the data file.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
PLS-00134: Pragma string expects 2nd argument to be an identifier or string-literal
DRG-10549: length of the object name string exceeded the limit
DRG-10846: order by columns must be all ascending or all descending
ORA-40221: maximum target cardinality exceeded
SQL*Loader-00515: Error getting CPU time
ORA-06144: NETTCP: SID (database) is unavailable
ORA-25138: %s initialization parameter has been made obsolete
ORA-27027: sbtremove2 returned error
ORA-27046: file size is not a multiple of logical block size
NMP-00005: general SNMP error
ORA-38424: no attribute set currently assigned to the expression set
ORA-13182: failed to read element string.string.string
Oracle Errors 
