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-39130: Object type string not imported. Base object name conflicts with the master table

1 Answers  


ORA-01618: redo thread string is not enabled - cannot mount

1 Answers  


ORA-15178: directory 'string' is not empty; cannot drop this directory

1 Answers  


ORA-39500: failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)

1 Answers  


ORA-24351: invalid date passed into OCI call

1 Answers  






ORA-02041: client database did not begin a transaction

1 Answers  


TNS-12509: TNS:listener failed to redirect client to service handler

1 Answers  


ORA-12528: TNS:listener: all appropriate instances are blocking new connections

2 Answers  


ORA-14052: partition-extended table name syntax is disallowed in this context

1 Answers  


TNS-12157: TNS:internal network communication error

1 Answers  


ORA-06761: TLI Driver: error sending orderly release

1 Answers  


PROC-00006: User does not have permission to perform a cluster registry operation on this key.

1 Answers  


Categories