ORA-29255: Cursor contains both bind and define arrays which is not permissible
Cause: 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 or SQL tables and array binds to bind PL or SQL tables to non-select queries.
Action: Modify your PL or SQL program to only perform calls to one of the two functions depending on the kind of cursor at hand.
Cause: 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 or SQL tables and array binds to bind PL or SQL tables to non-select queries.
Action: Modify your PL or SQL program to only perform calls to one of the two functions depending on the kind of cursor at hand.
No comments:
Post a Comment