SQL*Loader-00426: count of elements in VARRAY string comes
after the data for the varray
Answer / guest
Cause: The COUNT clause for a VARRAY field indicates that
the count of elements in the varray is stored in another
data field. However, that data field comes after the varray
data in the data file. Since finding the count field would
require SQL*Loader to know the number of elements in the
VARRAY first, SQL*Loader requires that the count field come
before the VARRAY data.
Action: Move the count field to be before the collection
data in the data file.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
TNS-01408: Instance "string", status string, has string handler(s) for this service...
ORA-13901: Object string was not found.
NID-00303: Datafile string - wrote new name
SQL*Loader-00503: Error appending extension to file (string)
IMP-00008: unrecognized statement in the export file: string
RMAN-06489: no configuration found to allocate clone channel number for device type string
PLS-00992: Cursor Variables cannot be FETCH'ed from
ORA-09913: Malloc of dummy name failed.
PCC-00086: Source file string has zero length
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-26565: Call to <type>_arg made before calling dbms_defer.call
IMP-00070: Lob definitions in dump file are inconsistent with database.