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

IMG-00800: internal error while parsing attribute string

1 Answers  


ORA-16129: unsupported dml encountered

1 Answers  


ORA-37107: (XSVPART07) Attempt to write to non-existent partition of workspace object.

1 Answers  


QSM-02049: subquery using the ANY clause in mv

1 Answers  


ORA-13464: error loading GeoRaster data: string

1 Answers  






ORA-12222: TNS:no support is available for the protocol indicated

1 Answers  


ORA-06805: TLI Driver: could not send datagram SAP packet for SPX

1 Answers  


ORA-19578: end of volume while duplexing to sequential files, backup piece incomplete

1 Answers  


ORA-24758: not attached to the requested transaction

1 Answers  


ORA-13434: GeoRaster metadata cellRepresentation error

1 Answers  


ORA-06560: pos, string, is negative or larger than the buffer size, string

1 Answers  


ORA-23466: flavor requires missing object "string"."string"

1 Answers  


Categories