Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


SQL*Loader-00426: count of elements in VARRAY string comes
after the data for the varray



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

Post New Answer

More Oracle Errors Interview Questions

SQL-02126: Count of array elements cannot be negative (i.e. < 0)

1 Answers  


ORA-23395: object "string"."string" of type "string" does not exist or is invalid

1 Answers  


RMAN-06609: AS COPY can be configured only for disk device

1 Answers  


ORA-10616: Operation not allowed on this tablespace

1 Answers  


ORA-06431: ssaio: Invalid Block number

1 Answers  






ORA-07590: spdde: $DELPRC failure

1 Answers  


QSM-00509: invalid parameter

1 Answers  


DRG-10531: parallel parameter must be > 0

1 Answers  


TNS-01112: Plug and play can either be ON or OFF

1 Answers  


ORA-13009: the specified date string is invalid

1 Answers  


SQL-02113: Unable to open message file

1 Answers  


ORA-09208: sftcls: error closing file

1 Answers  






Categories