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

ORA-00258: manual archiving in NOARCHIVELOG mode must identify log

1 Answers  


ORA-02722: osnpui: cannot send break message to orapop

1 Answers  


RMAN-08098: channel string: validation complete

1 Answers  


ORA-26001: Index string specified in SORTED INDEXES does not exist on table string

1 Answers  


ORA-06254: NETNTT: cannot share connection to cube

1 Answers  






ORA-24079: invalid name string, names with AQ$_ prefix are not valid for string

1 Answers  


ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

1 Answers  


ORA-01185: logfile group number string is invalid

1 Answers  


SQL*Loader-00644: end of logical record found when reading length of varying length field

1 Answers  


RMAN-03031: this option of set command needs to be used inside a run block

1 Answers  


NZE-29031: SSL handshake is required.

1 Answers  


ORA-25289: Buffer Already Exists

1 Answers  


Categories