SQL*Loader-00487: COUNT clause required for collection string
- 1 Answers
- 2301 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: A VARRAY or NESTED TABLE was defined in the SQL
Loader control file and all of the fields in the VARRAY or
NESTED TABLE are generated by SQL Loader and do not come
from a data file. SQL Loader requires a COUNT clause be
specified so that it knows how many elements to add to the
VARRAY or NESTED TABLE for each row.
Action: Add a COUNT clause to the VARRAY or NESTED TABLE
definition.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
PLS-00951: %s Feature is not supported by this release
ORA-37027: (XSMLTRESYNC02) Object workspace object cannot be resynced without modified object workspace object because they share a modified composite dimension.
LSX-00021: undefined element "~S"
ORA-12482: internal MLS error: string Error: string
DRG-12900: Operation:string for index: string has already been started
PCC-00025: Undeclared indicator variable "string" at line number in file string
ORA-23301: mixed use of deferred rpc destination modes
ORA-13208: internal error while evaluating [string] operator
AMD-00135: measure #string: RDBMS measure column data type not specified
CLSR-00521: Event string is rejected by EVM daemon
ORA-26099: direct path context is already prepared
TNS-00246: Connection Manager: Failed to start tracing
Oracle Errors 
