ORA-29252: collection does not contain elements at index
locations in call to dbms_sql.bind_array



ORA-29252: collection does not contain elements at index locations in call to dbms_sql.bind_array..

Answer / guest

Cause: The bound table does not contain elements at both
index locations in call to bind_array of dbms_sql. This is
illegal. Both index locations must contain elements. In
other words tab.exists(index1) and tab.exists(index2) must
both return true.

Action: Either modify the two indexes or the contents of the
table and try the 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

SQL*Loader-00603: Maximum length number of column string is too big for bind array

1 Answers  


ORA-13147: failed to generate MBR

1 Answers  


TNS-12548: TNS:incomplete read or write

1 Answers  


DRG-50852: failed to turn SQL trace on

1 Answers  


QSM-02178: MV has a view with UNION ALL that is not fast refreshable

1 Answers  






TNS-00507: Connection closed

1 Answers  


ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)

1 Answers  


ORA-37106: (XSVPART06) Invalid partition name number.

1 Answers  


ORA-30951: Element or attribute at Xpath string exceeds maximum length

1 Answers  


LSX-00243: invalid date "~S"

1 Answers  


ORA-13762: The string ranking measure is invalid.

1 Answers  


PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records

1 Answers  


Categories