ORA-06569: Collection bound by bind_array contains no elements



ORA-06569: Collection bound by bind_array contains no elements..

Answer / guest

Cause: A collection with zero elements was bound to a bind
variable in a call to procedure BIND_ARRAY in the package
DBMS_SQL. In order to execute a bind of a collection, the
collection must contain at least one element. If no elements
are present then at execute time there will be no value for
this bind and the statement is meaningless.

Action: Fill the collection with the elements you want to
bind and try the bind call again.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07209: sfofi: file size limit was exceeded.

1 Answers  


QSM-02014: GROUP BY expression other than a column

1 Answers  


QSM-02044: ORDER BY clause in mv

1 Answers  


ORA-14400: inserted partition key does not map to any partition

1 Answers  


RMAN-08159: executing global script: string

1 Answers  


PCC-01017: The SQLCA and a SQLCODE variable cannot both be used

1 Answers  


IMP-00050: Dump file and log file cannot be identical

1 Answers  


PLS-00599: SAMPLE percentage must be in the range [0.000001,100)

1 Answers  


ORA-14640: add/coalesce index partition operation is valid only for hash partitioned global indexes

1 Answers  


ORA-01678: parameter string must be pairs of pattern and replacement strings

1 Answers  


ORA-01500: failure in getting date/time

1 Answers  


ORA-13610: The directive string does not exist for task string.

1 Answers  


Categories