Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-29251

DBMS_SQL.BIND_ARRAY: parameter index1 is greater than parameter index2.

Cause

The value for parameter index1 was greater than the value for for parameter index2 in the call to DBMS_SQL.BIND_ARRAY. This is invalid because the elements of the table that will be bound are those with indexes greater than or equal to index1 and less than or equal to index2.


Action

Correct the value of the two parameters and try the call to again DBMS_SQL.BIND_ARRAY.