Oracle DB Error ORA-29255 Cursor contains both bind and define arrays which is not permissible

The following is the cause of this error:

Both DEFINE_ARRAY and BIND_ARRAY have been called on this cursor. This is illegal. It is not possible for a cursor to both contain array binds and array defines. The semantics of this setting are nonsensical. Array defines are used to move data from select queries into PL/SQL tables and array binds to bind PL/SQL tables to non-select queries.

Action you can take to resolve this issue: Modify your PL/SQL program to only perform calls to one of the two functions depending on the kind of cursor at hand.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related